Can anyone please help me to solve this problem.I want to create a pivot in which I want to hide a row,but my percentage should be calculated out of the total.
Please refer to the Pivot sheet in the attached excel sheet.The first pivot is the default pivot what the qlikview creates , but I am want to create the second pivot .
If you observe my percentage are coming from the totals even when I am not displaying the a)current in the pivot.