Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

4 Replies
Not applicable
Author

sort by Y-value descendingen

Not applicable
Author

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

Not applicable
Author

Any idea please?

skchen97
Contributor
Contributor

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