Discussion board where members can get started with QlikView.
Hi, I have a pivot table with survey questions done by different category of users.
I want to hide category 3 but the total value should include the Q1 and Q2 values from Category 3. can this be done? please help
Go to Solution.
Can you try this?
View solution in original post
Here it is
Please see attached. I did this using calculated dimension. Is this you want?
Thanks for the help. I have managed to hide the rows but the total is affected though i have followed the same method. the total excludes the hidden rows values. Is there any other way to prevent this?
If you did like that means there is no sense in business terms. 5 + 10 = 20 means its not a correct your approach is wrong