9 Replies Latest reply: Nov 29, 2016 10:13 AM by Sunny Talwar RSS

    Bar chart how to calculate a percentage

    Ian Hughes

      All;

             I am in the process of creating a bar chart that shows a total dollar amount for each division and the colour shows the total number of transactions.   I would like to add the percentage of transactions for each division out of the total. Any ideas on how I can do this please?

       

        I am drilling down to get to this point and so I am not clear on how to generate the total transaction count to be used as the denominator for the percentage calculation

       

        Thank you in advance

        Ian