Background color depending of accumulated sum(sales)

[#1]

Hi,

I would like to show a chart with two expressions:

• sum(Sales) -> bar
• sum(Sales) [accumulated] -> line/points

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

[swuehl · Accepted solution]

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.

[#3]

Works perfect, thanks for the thought-provoking impulse!

[#4]

hi sorry to trouble, could you attach a picture of it so I could refer to? I'm facing the same issue..