show all dimension values based on selections

[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

[Anonymous]

Its not the best practice but a quick fix would be to use buttons that make those selections.

[Anonymous]

country is lower case c

[olivierrobin]

hello

if Sales for ALL the sum of other countries ?
If Yes, i wouldn't load ALL, and no by the normal qV mechanism, if you don't select anything, you have the total

and if you select a country, you have only this country