Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you are experience a common Aggr() pit fall, a dimensional grain mismatch.
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))
I think you are experience a common Aggr() pit fall, a dimensional grain mismatch.
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))
Yes!! With TOTAL it works. Thanks for the solution and the blog link!