11 Replies Latest reply: Apr 26, 2016 3:00 PM by Jagveer Dhillon RSS

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

    Jagveer Dhillon

      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.