Hi all,
I have a requirement like that:
We have Company and Brand characteristics in the rows. And salesquantity in the columns.
After executing the report, i mean in the report output, user will need to hide some of the lines. For example, he/she will want to hide some of the Brands under Brand column. We don't want to use 'filter' functionality, since it will change the result row. We dont want to change result line at all ! All Brands have to be included to the result calculation but some of them (based on the user selection) can be hided in the output. We can not use 'Condition' function since it can be applied based on keyfigure.
Let me exemplify my scenario:
Company Brand SalesQuant.
A...............result............100
.......................x..............30
.......................y..............20
.......................z..............50
User want to see result row (100). And after hiding Brand 'z', result line should be again 100.
Is this possible?
Thanks in advance.
Sancho
Edited by: Sancho Pannza on Feb 9, 2009 9:12 AM