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.



      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.