5 Replies Latest reply on Dec 21, 2016 5:34 AM by pulak.jayaswal

# How to perform calculation between 2 rows of same dimension

Hi ,

I have  1 Dimension and 1  Measure as below.

Name (Dimension)       Speed (Measure)

John                              40

Roy                               50

Alan                              60

Now I want to calculate Rate of speed for Alan and John. Formula I want to implement is (60-40)/60

Any Idea how I can do this in Tableau.

Thanks

Pulak

• ###### 1. Re: How to perform calculation between 2 rows of same dimension

Here you go.

Thanks,

Shin

• ###### 2. Re: How to perform calculation between 2 rows of same dimension

Hi Shin,

I highly appreciate your quick response and the solution you provided.

I want to calculate in below manner-

(60-40) / 60 = 0.33%. Can you please advise on this??

Thanks

Pulak

• ###### 3. Re: How to perform calculation between 2 rows of same dimension

Hi Pulak!

Probably this is what you are looking for.

Regards,

Sireesha.

1 of 1 people found this helpful
• ###### 4. Re: How to perform calculation between 2 rows of same dimension

Change John to Alan in the "Name".

Thanks,

Shin

1 of 1 people found this helpful
• ###### 5. Re: How to perform calculation between 2 rows of same dimension

Hi Shin, Sireesha

Many thanks for solution and help.

Regards

Pulak