1 Reply Latest reply on Jul 13, 2018 10:29 AM by Yuriy Fal

    Add a grand totals Column

    Scott Schmeling

      Hi I was hoping someone could tell me the best way to add a grand totals by category column. 

       

      I have attached a WB it was done in 10.3. 

       

      Right now I have a Sheet that looks like:

       

      2017 Q32017 Q42018 Q12018 Q4
      MCAProv NameProv SpecABTotalABTotalABTotalABTotal

       

      I want to add one more series of Columns at the end that show

      Grand TotalHeader 2Header 3
      ABTotals

       

      Any suggestions would be appreciated.  I have tried a LOD but the issue is getting it to sit at the end of the table in line with the Prov Name.  The formula I used was:

       

      {fixed [Category], [ProvName]: Sum(Counts)} 

       

      I just can't seem to get it to align at the end of the table.

       

      Thanks,