4 Replies Latest reply: Oct 14, 2014 5:02 AM by Ashwani Kumar RSS

    Function to get all of 1 dimension

    Steve Zagzebski

      I need to be able to create an expression that would give revenue by area for group 1 divided by the revenue of by area for ALL groups. I have tried different ways (using TOTAL) but can't get it to do what I am looking for...

       

      GroupAreaRevenue
      1North$
        1,000.00
      1South$
        2,000.00
      1East$
        3,000.00
      1West$
        4,000.00

       

      Note: I need to be able to filter on Group 1 in this example.

       

      Thanks in advance...