3 Replies Latest reply: Jun 23, 2015 3:36 AM by Magnus Lander RSS

    Some static bars in chart?

    Magnus Lander

      Is it possible to have some of the bars remain constant when drilling down in the others? Is set analysis the way to do it?

       

      The chart displays sales by customer group (10 highest). If we drill down, the chart shows sales per customer. But I'd like the red inked bars in the image to continue displaying customer group and not customer. The ones on the left should change as usual.

      I have unique codes per customer group and customer.

       

      I tried with: sum( {$<[CustomerGroup]={'CG1', 'CG2', 'CG3'} [SalesAmount] ) and it displays the red inked bars fine but the others are displayed incorrect.

      qv.PNG