14 Replies Latest reply on Jan 22, 2013 10:12 AM by Kevin Sullivan

    Avg and Sum depending on dimension

    Kevin Sullivan

      I have a dimension named Waterfall Categories with 13 categories....  within these 13 categories there are 2 that I want be average and the 11 other categories to be sum.

       

      I know this calc does not work but this is what I am looking to do....

       

      If [Waterfall Categories] = "Previous Month" then AVG([Waterfall#]) else If [Waterfall Categories] = "Current Month" then AVG([Waterfall#]) else Sum([Waterfall#]) End