3 Replies Latest reply on Jun 3, 2016 8:44 AM by Mahfooj Khan

    How to calculate % of Total for Aggregate Measures?

    Ramesh Krishnan

      Hello Helpers,

       

      I have an aggregate measure, which is a ratio (could be greater than 1). When I try to calculate % of Total, I am not getting the expected result.

      Below is the screenshot of just the measure (without the table calc).

      Agg % of total - normal.png

       

      Below is the screenshot of the measure with the % of total calculation. I added table calc and chose table down.

      Agg % of total - calc.png

       

      I expected the measure to be scaled to 100%, but then this is very wayward! Please tell me what I am missing here!

       

      Thanks,

      Ramesh