Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
You are awesome!!!!!!!!!!!