Pivot Table Problem with IF statement

[qobo_qwaka]

Good day everyone,

I have a pivot table with 3 dimensions (Group, Name, Status) and 1 expressions. The usual selections are group and name, but group is not always available. I am using an if statement : if(IsNull(Group), MaxString(JUDGEMENTS), MaxString({<Name=>}JUDGEMENTS)). 

If here is no group then I want the the expression to return only information for the selected name, but if there is a group then i want to ignore the name selection and return information for all names in the group.

Individually these two formula give me what i want but for some reson they don't work in the if statement. 

Your assistance will be highly appreciated.

[pradosh_thakur]

Where are you using the expression ?

Try the below may be

if(len(trim(Group))=0, MaxString(JUDGEMENTS), MaxString({<Name=>}JUDGEMENTS))

[qobo_qwaka]

Hi Pradosh, 

It doesn't work. I returns only the selected name even though the ignored by the if statement. 

However what confuses me id that if i say the following it returns correct results.

if(len(trim(Group))=0, 'Yes', 'No')

[pradosh_thakur]

If you are using it in a dimension it may not work. in expression it should.

P.S. : I am sorry if i missed out on the reply as i am not getting notification of your replies. Please tag some other member who can help.