2 Replies Latest reply on Jul 4, 2016 2:21 AM by Eshwar Prasad

    % Calculation with out Table Cals

    Eshwar Prasad

      Hi Team,

       

      Below is my requirement.

       

      I need to show the top N Items on the Pis based on the sales and i need to show the % also.

      Here  the problem is  i need to show the % of each item out of all items sales amount. not only out of Top N items which are showing on the Pie chart.

       

      for example Global Troy™ Executive Leather Low-Back Tilter is the Top item. But its % out all items is 1.7%. But in the Pie Chart 23% as it is considering only on Top 5.

      Can any one help how to get this % out of all items sales amount.

       

      PFA for ur reference.