5 Replies Latest reply: Apr 22, 2013 3:54 AM by Hans Tubbax RSS

    filter affects background color of expression

      I created a Trellis barchart with 2 dimensions (territory and orderyear) and 1 expression (sum of OrderSubTotal)

      In order to avoid that document filters effect the chart, the {1} set identifier is used in the expression =Sum ({1}OrderSubTotal)

      To emphasize the last year, the background color of the expression was changed to =if(OrderYear=$(LastYear),lightred(),color(1))

      If you filter the data, e.g. territory='Europe', the values of the chart don't change, but the background color is also filtered (see screenshot)

      How to overcome this problem?