2 Replies Latest reply on Jul 16, 2018 4:00 PM by Scott Schmeling

    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,

        • 1. Re: Add a grand totals Column
          Yuriy Fal

          Hi Scott,

           

          You may want to exploit some properties of your data, namely,

          the existence of [Category] = 'Total' dimension value.

           

          With that you'd skip the [Category] dimension Sub-Totals --

          leaving only Row Grand Totals on the view.

           

          You may want to use Measure Names / Measure Values

          (as the rightmost pill on Columns) to get the desired layout.

           

          Please find the attached.

           

          Yours,

          Yuri

          • 2. Re: Add a grand totals Column
            Scott Schmeling

            Thanks Yuri,

             

            Unfortunately it is a little more complex than that and it lost the levels when I posted.  We are unable to post any workbooks as it is all proprietary but we were able to find a way around the issue.  I'm not sure how the developer did it, as I am not actually on this project was just looking to help them out and learn something in the process.

             

            Thanks,