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

[YoussefBelloum]

Hi,

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

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

[jmvilaplanap]

Hi,

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

Regards

[Anonymous]

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.

[YoussefBelloum]

EDITED

so try this:

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