Hello,
I have a pivot chart with two demensional layers (Territory and Sub-Territory). My expression is correct when I am looking at the sub-territory level. However, when I drill back to look at it on a territory level, the expression is not totaling rows...it is computing on a territory level with is essentially averaging the sub-terriotry values. Is there a way to make this expression sum rows when looking at the top most level?
Thanks,
Jeff