5 Replies Latest reply on Sep 21, 2018 8:54 AM by Anuka Teggart

    Grand total not correct of blended data for YoY comparison

    Anuka Teggart

      Hi there,

       

      I wish to get the correct totals of the Deterioration and Release columns shown below (i.e. 9569 for Deterioration and -8987 for Release) from a YoY comparison (my real data is MoM if that makes any difference).  Have attached an example workbook.

       

      I've duplicated the data and blended them on This Year = Last Year so I can avoid table calcs for the grand total difficulties.

       

      I'm aware it's happening because the total is being calculated separately but I've not found a way to get around this.  Any help would be greatly appreciated.

       

      Thanks in advance!

      Anuka