aggr suppresing a row

[#1]

Hi Everyone ,

I created a pivot chart with a aggr expression . What is happening is by default without any selection it is suppressing the rows . But whenever i select a item it gives me the right answer .Any one has any idea why this happens .

thanks..

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

That is what teh Aggr() function is expected to do. Use instead

Aggr(NODISTINCT expressionhere)

and you should see all values in all rows, repeating when required.

Hope that helps.

Miguel

[#3]

that worked thanks .. but no idea why it worked!!!.  because the dimension (item )are not similar in any way ...

so my expression should have returned that suppressed row .