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


      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.



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




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