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

[#1]

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

[#2]

sort by Y-value descendingen

[#3]

Thanks for your answer.

But I had already tried this sorting and it doesn't work .

Indeed if I sort by Y-value descending the cumul ratio is false

[#4]

Any idea please?

[skchen97]

Load the same set of data group by dimension columns with sum and sort by sum