Some static bars in chart?

[magnuslander]

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.

[Anonymous]

Why not use 2 seperate charts, one for the fixed bars and the other for the bars that change.

[hic]

Try

     Sum( {$+1<[CustomerGroup]={'CG1', 'CG2', 'CG3'} [SalesAmount] )

HIC

[magnuslander]

Thanks! Almost! The problem with $+1 is that CG1 is dropped from the view. CG2 and CG3 display fine. I guess because it's not one of the 10 highest?