5 Replies Latest reply on Jan 11, 2017 4:18 AM by Jonathan Drummey

    Total Using Option Not Working

    Hernan Lee

      I am trying to have one of my column's subtotal SUM everything, but the option is greyed out. I believe this is due to the Measure Value being a table calculation. I can't share my workbook due to sensitivity of our client's data, but any help would be appreciated.

       

      Screen Shot 2017-01-10 at 10.13.50 AM.png

       

      The Measure Value calculation looks like this, where "Weight" is a proportion of total.

       

      Weight:

      Screen Shot 2017-01-10 at 10.23.38 AM.png

       

      Weighted PTG:

      Screen Shot 2017-01-10 at 10.22.44 AM.png

       

      After using in column and trying to SUM the subtotal, I get this:

       

      Screen Shot 2017-01-10 at 10.13.29 AM.png

       

      Thank you.