How to hide dimension value when a column ignore the selection of this dimension?

[chenriot]

Hi,

I have a straight table with one dimension "reps" and 2 expressions :

- one that sum revenue

- one that sum revenue for all reps (so with ignore reps selection in set analysis).

My problem is that when I select one rep, all reps are displayed in the table with only the first expression calculated for the rep I selected and the second expression is calculated for all reps. I would like only the line with the rep selected displayed in the table.

In the example below, I would like only the line with Rep5 displayed.

How can I do this ?

Thanks in advance for your help

[PradeepReddy]

1st Expression: sum(Revenue)

2nd Expression: Sum(Total{<Rep=>} Revenue)

[chenriot]

Thanks for your answer.

It works

[chenriot]

Thanks for your answer.

It works