Aggr function in Expressions

[Anonymous]

Hi,

Should somebody explained to me why the expression Aggr(Sum(WorkedHours), ProductionID) gives the same results for all the rows in a pivot table if I put it on the Dimensions section and it gives the result only for the first row if I put it on the expression section?

Thanks,

N.

[swuehl · Accepted solution]

It's probably due the chart dimension context. Have a look at the grain mismatch section in

Pitfalls of the Aggr function

[Anonymous]

You're right.

Thank you so much.

N.