show dimension values based on condition

[Anonymous]

Hi All,

  Please find the below table.Country dimension as list box if i selected ALL ,in the pivot table i want to show all countries except ALL  otherwise it should show selected country.

country	Sales
ALL	40
IND	20
USA	10
UK	10

[felipedl]

Hi,

Create a variable with the following:

=if(only(country)='ALL','{<country=e(country)>}','{<country=P(country)>}')

And as an expression, use:

sum($(vSetAnalysis)Sales)

With this set, when you select ALL, it gets the excluded values for the country filter (getting all values besides the 'ALL' value) and when selecting anything else, it gets the possible values.

Pictures for reference:

1. Variable creation

2. Expression:

Felipe.