4 Replies Latest reply on Sep 25, 2017 10:33 PM by Sriram Bharat

    Pie Chart-Parameters-10.3

    Sriram Bharat

      I have a pie chart with product  category in colour and there are two parameters.

       

      When I select the "Percentage" parameter i am getting the percentage of Sum([Profit])/Sum([Sales]) and when i select the "Absolute" parameter i should get the sum of sales.

       

      I have written 3 calculations in total.

       

      The issue i'm facing is - the sum of sales is also getting displayed as a percentage instead i should get the sum of sales per category displayed.

       

      My query is in Sheet 3.