Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Act sooner with Multivariate Time Series in Qlik Predict™: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hide row in pivot table

Hi All,

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.

Thanks,
sonal

0 Replies