PivotGrid - Expression - Aggr with less dimension

[#1]

Hi! I'm using a pivot grid

I need an expression with a calculated value using every dimension in pivot grid except one.

I can't show this value in every record of the pivot grid.

I attach an example:

Thanks

[swuehl · Accepted solution]

I think you are experience a common Aggr() pit fall, a dimensional grain mismatch.

Pitfalls of the Aggr function

Try

=sum( Aggr(NODISTINCT ($(tMontoTraza_Pura)),PTOEspecie,MANIDestino,PTOProduccionTipo, PTOCalidad,PTORango_Ag))

or maybe

=sum(TOTAL<PTOEspecie,MANIDestino,PTOProduccionTipo, PTOCalidad,PTORango_Ag>

Aggr( ($(tMontoTraza_Pura)),PTOEspecie,MANIDestino,PTOProduccionTipo, PTOCalidad,PTORango_Ag))

[#3]

Yes!! With TOTAL it works. Thanks for the solution and the blog link!