Grand Total Problem


  • I am creating a PivotTable using PowerPivot in Excel 2013 that shows sales by month. I have created a calculated field to show the sales for the corresponding month of the previous year using this formula:


    This work ok, except for the Grand Total row which shows the value from the last month in the table, instead of the total of all the months. I am trying to figure out what is causing this and how to fix it.

    Thursday, November 07, 2013 2:11 PM


All replies