Skip to main content
Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Background color depending of accumulated sum(sales)

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

3 Replies
swuehl
MVP
MVP

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.

Not applicable
Author

Works perfect, thanks for the thought-provoking impulse!

Not applicable
Author

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