7 Replies Latest reply on Jun 3, 2016 12:02 PM by Ramesh Krishnan

    Challenge for Tableau Experts: How to create % of Total for Aggregate Measures? Need it scaled to 100%

    Ramesh Krishnan

      Pooja Gandhi

      Hello Experts,


      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%, something like the below image (I got this using a single measure, not the aggregated ratio measure)

      Please tell me what I am missing here!