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

# Can I perform different calculations on two different dimensions?

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?

• ###### 1. Can I perform different calculations on two different dimensions?

"Compare" how?

--Shawn

• ###### 2. Re: Can I perform different calculations on two different dimensions?

I imagine this being a bar chart with dimensions being (My Client #, the average other client)

"My Client #" would show a sum of the transaction amounts.

The "average other client" would display an average of the sums of the other two clients.

• ###### 3. Re: Can I perform different calculations on two different dimensions?

Post some sample data and I'll give it a go.

--Shawn

• ###### 4. Re: Can I perform different calculations on two different dimensions?

Hi Eric,

You should be able to do this by creating a couple of calculated fields.

The first calculated field would be find just the value for your client.

if [Client]="Client1" then [Measure] end

The second calculated field would find the value for the other two clients:

if [Client]="Client2" or [Client]="Client3" then [Measure] end

Then, you can place these on the view together side by side.

The Client field would not need to be on the view.

Hope this helps!

-Tracy