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

[alexdataiq]

You can go to the Expression Tab and check the conditional box and use the expression:

If(GetSelectedCount(Rep) >= 1, 0, 1)

Regards

[MarcoWedel]

please post a sample application

regards

Marco

[kkkumar82]

Hi,

If you want the thing what you required then where are you using the second column.

Better post sample qvw with some dummy data.

Thanks

Kiran K

[Kushal_Chawda]

What is the expressions for Total revenue and revenue?

[jagan]

HI,

Try like this

Expression -> Select Conditional -> and give below expression

=GetSelectedCount(Rep) = 0

I think there is no meaning of adding the second expression if you are hiding when Rep is selected.

Regards,

Jagan.

[tyagishaila]

What is the use of Total Revenue?... if you don't want to show all reps after any rep selection.

[chenriot]

Hi,

thanks for all responses.

In fact, I have 2 problems :

1. In the example, I would like the "total revenue" column with the value 420 (sum of revenue without take care about the rep selected)

2. I would like only the row displayed for the rep selected.

This is the result I would like :

Thanks in advance for you help

[tyagishaila]

Revenue:             Sum(Revenue)

TotalRevenue:     Sum(Total{<Rep=>}Revenue)

[tyagishaila · Accepted solution]

Hope it will work