4 Replies Latest reply: Jun 18, 2013 4:49 AM by sk chen RSS

    Problem of sorting values in a pivot table (to get an accumulation of ratio)

      Dear all,

       

      I need your expertise to realize a cumulated/cumulative ratio in a Pivot Table.

       

      Indeed you can see in my example that I meet some difficulties :

       

      - the sorting (column Rank) doesn't work like I want. My values must be sorted by decreasing Turnover (even if I decide to collapse or expand all)

       

      - since my column Rank is false, you can see my columns Ratio and Cumul Ratio (which accumulates the values of the column Ratio) are false too

       

       

      Thanks in advance for your feedbacks,

       

      Best regards,

       

      Benjamin