Invalid dimension error in Table

[#1]

Hi All,

I am using the following expression on one of my dimension in table, and it is throwing an error - Invalid dimension.

Formulae:

if(GetSelectedCount(COUNTRY) = 0,

   only({$<COUNTRY = {'England'}>}COUNTRY),

       COUNTRY)

Please correct me if anything implemented wrongly

Thanks in advance

[#2]

Thank you chanty. Its working

[Chanty4u]

good to here   please close this thread by making correct and helpful answers above

Best

Chanty

[jonathandienst]

vinay rr wrote:

Can I have a small background why its working with aggregation only??

Aggr() creates a vector of values for the dimension (one per value of COUNTRY) and the expression operates on the vector, filtering out all the values except England when there is no selection. Otherwise the vlues are filtered (by Aggr()) according to the selections.