4 Replies Latest reply: Oct 18, 2016 8:11 PM by Malaika S RSS

    Pivot Table percentage calculation not working

    Malaika S

      Hi,

       

      I have added two dimension in a pivot table ie Customer Name and Rank Function to show Top 50 records. Expression - sum of the values and percentage calculation. Percentage calculation is based on Products/Total Products for each customers. I am getting the percentage nos for all the traders but for total it doesnt work. Total column has been added by checking partial sums.

       

      I need to find  resolution asap. Hence any help in this regard will be highly appreciated.

       

      Thanks,

      Malaika