Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BI7 Workbook - Rows Hide

Hello Gurus

We need to hide 50 rows in Query Result set area. I am calculating percentage based on the result of each column . In the output we have 100 rows . user wants to see only 50 rows in the report.

Case 1

  • I cannot use conditions . so I cannot use it .

Case 2

I cannot use filter on that column . Becasue i am calculating percentage for each cell based on the entire result of the column.

Option i am left with is to convert to workbook and hide the rows and use the result to calculate the percenatge for remaining rows.

I am unable to achive it in workbook. please through some light in tunnel .

We are on BI7.

Thanks

CC

Former Member
Not what you were looking for? View more on this topic or Ask a question