show dimension values based on condition

Anonymous — Tue, 22 Jul 2025 17:59:49 GMT

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

Re: show dimension values based on condition

felipedl — Tue, 22 May 2018 12:45:25 GMT

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.

topic Re: show dimension values based on condition in Archived Groups

show dimension values based on condition

Re: show dimension values based on condition