Display expression at a certain level only

Mon, 03 Sep 2012 19:42:15 GMT

I have a pivot chart which looks like this:

How can I display the expression, only at the Total Level? and looks like this:

This is because SaleReps is a numeric column coming from a less granular table

thanks in advance

Re: Display expression at a certain level only

Anonymous — Mon, 03 Sep 2012 20:45:24 GMT

Modify the expression:
if(dimensionality()<=1, sum(SaleReps))

Regards,
Michael