BI7 Workbook - Rows Hide
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.
I cannot use conditions . so I cannot use it .
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.