5 Replies Latest reply: Sep 6, 2013 6:33 AM by Andy Myers RSS

    Create a Calculated Dimension in Pivot Table?

      I have three dimensions. 'Product','ArticleNo','Week' and an expression 'Units Sold'. The table is pivoted on 'Week' dimension with 'Units Sold' is its measure of expression. Now I need to add average as a Calculated Dimension, which should calculate overall average of 'Units Sold'. Anyone, how can I do this?