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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to hide a particular row in pivot but include it in the calculation

I have a Pivot table where I just want to show the previous month and current month data but for the yearly data I want to include everything in calculation. As shown in the image below, the highlighted row needs to be hidden but included in the total calculations.

Untitled1.png

11 Replies
Not applicable
Author

All right, this might sound a bit irritating to you, but i tried this as well, and in this case, 2015-YTD gets suppressed since the month is null for that period.

Not applicable
Author

You are awesome!!!!!!!!!!!