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

    Background color depending of accumulated sum(sales)



      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!