Skip to main content
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!!!!!!!!!!!