6 Replies Latest reply on Dec 11, 2018 3:01 AM by Simon Runc

    Sum based on value of dimension

    Chuck Blechle

      I am trying to sum based on the value of a dimension.  I need to sum values for two independent groups based on their dimension value.  I will then need to dived the resultant sum of the two groups.

       

      In my example

      Group 1

           would sum [Price] if [Transaction Type] is 'Full Service' or 'Maintenance'

      Group 2

           would sum [Price] if [Transaction Type] is 'Elimination' or 'Quoted' or 'T&M'

       

      I will then need to divide Group 2 by Group 1 to get a ratio by [Team]

       

      Thank you for you help.