3 Replies Latest reply on Apr 8, 2013 10:03 PM by Prashant Sharma

    Total SUM only for given Dimension's members

    Armando Ramirez

      Hello

       

      I have 2 Dimensions, Region and Categories.

      Then I have a one simple metric as shown in the following pic:

      p1.png

      Then I would like to have a SUM of the metric only for some given members as shown in the following:

      p2.png

      This is the Total SUM of the amounts for Category F through J

       

      Please find workbook attached

      Any ideas any help?

      Thanks!!