none
Grand Total Problem

    Question

  • 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:

    SalesMTDPreviousYear:=CALCULATE(SUM(SalesFacts[Total]),DATESMTD(DATEADD(DateDimensions[Date],-1,YEAR)))

    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

Answers

All replies