4 Replies Latest reply on Feb 22, 2013 1:39 PM by Tracy Rodgers

    Can I perform different calculations on two different dimensions?

    Eric Schell

      I have data from 3 separate clients that breaks out into 3 different transaction types each with an associated amount.

       

      Example: Client 1     Type 1

                                     Type 2

                                     Type 3

                     Client 2     Type 1

                                     Type 2

                                     Type 3

                     Client 3     Type 1

                                     Type 2

                                     Type 3

       

      I want to sum the transaction amounts for Client 1 and compare that to the average sum of Client's 2 and 3.

       

      Is this possible?