How to show result for selection in dimensions.

[Peony]

Dear All!
Please, help me to solve the issue.

I have several Dimension, in the example, there is _AAA and _DDD. And I have the text object to show what particular dimension has the selections. If the selection only in _AAA  in the text object should be "A". And if the selections in _AAAand _DDD or in _DDD only it should be "D".

The issue is that I don't understand how to create a condition in the text object to get "D" as the result. I tried to use if-statement and GetSelectedCount(). But it is enough only to get "A" answer. 

[tresesco · Accepted solution]

Try this:

=if(GetSelectedCount(_DDD)>0, 'D', (If(GetSelectedCount(_AAA)>0,'A')))

[Peony]

Works perfectly! Thank you!