3 Replies Latest reply: Jun 9, 2015 5:03 AM by Clare Sim RSS

    Background color depending of accumulated sum(sales)

    Thomas Schmutz

      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