Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to show a chart with two expressions:
The sort order should be descending for the accumulated sum(Sales). The X-largest values that accumulated to Z% should be shown dynamically in background color darkgray(), the others in lightgray().
Up to now I tried it with 'limited dimensions', 'pareto selection' and 'Aggr(RangeSum(Above(Sum(Sales)...' but didn't succeded.
The problem is show on the first tab in the .qvw, what I already tried on the second tab.
Would be grateful for any help!
cheers
Thomas
Yes, the limitiation of column sort order when using chart inter record functions like above() is kind of annoying.
But try maybe a a pareto select in an alternate state. Please check attached sample.
Yes, the limitiation of column sort order when using chart inter record functions like above() is kind of annoying.
But try maybe a a pareto select in an alternate state. Please check attached sample.
Works perfect, thanks for the thought-provoking impulse!
hi sorry to trouble, could you attach a picture of it so I could refer to? I'm facing the same issue..