Discussion Board for collaboration on QlikView Layout & Visualizations.
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,
sort by Y-value descendingen
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
Any idea please?
Load the same set of data group by dimension columns with sum and sort by sum