Set Analysis Not Working

[cristian_av]

Hi

I'm trying to use set analysis to ignore  the "GrupoCalibre" dimension, but it is not working.

I'm using the following expression:

=Sum({$<GrupoCalibre=>} KilosPronCalib)/1000

What is wrong with this?

Thanks!

[swuehl · Accepted solution]

To ignore dimensions, use the TOTAL qualifier:

=Sum( TOTAL<Especie,Variedad> KilosPronCalib)/1000

The Aggregation Scope