0 Replies Latest reply: Jan 16, 2012 1:58 PM by jhoffef15 RSS

    Expression issue

      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