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

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

YoussefBelloum — Tue, 22 May 2018 08:27:55 GMT

Hi,

on the dimension of your pivot table, you can do this:

=if(country<>'ALL',country)

Re: show dimension values based on condition

jmvilaplanap — Tue, 22 May 2018 09:06:20 GMT

Hi,

Maybe the easiest way is eliminate the row "ALL", because is a SUM of the other rows.

Regards

Re: show dimension values based on condition

Anonymous — Tue, 22 May 2018 09:13:18 GMT

Thanks,it's not working,if i selected ALL its showing - but its should display all values , if i selected others values its shows that value.

Re: show dimension values based on condition

YoussefBelloum — Tue, 22 May 2018 09:20:48 GMT

EDITED

so try this:

=if(GetFieldSelections(country)='ALL', only({<country-={'ALL'}>}country), country)