4 Replies Latest reply on Apr 6, 2016 12:19 AM by Olya Makarova

# How to create percent difference column with several mesures in rows?

Hello everyone!

I need to present data about several measures (uv, vv) by several categories (platform) in comparasion of yesturday and week before.

And I need present percent difference for every row.

How can I do that?

The closest thing I can do is the following:

Can I make cell calculation in tableau? Something like (=c2/b2*100) and then expand for every row in Exel?

With help of this tutorial: Adding a Calculated Column to a View | Tableau Software

I get this dashboard:

It look exactli as i need, BUT there are 2 different not connected tables, they just visually aligned.

I need it to be in 1 table... Is it possible?

ps example updated

Сообщение отредактировано: Olya Makarova

• ###### 1. Re: How to create percent difference column with several mesures in rows?

Use the function LOOKUP to do this.

Hope this will give you solution

• ###### 2. Re: How to create percent difference column with several mesures in rows?

Hi!

Thanks for quik respond.

But I not quite understand how one more calculation can solve my question...

I do understand how to calculate things if they are same meausere in different categories, but I have different mesuars in rows.

In real data it would be 11 mesuares in 3 platforms = 33 rows.

And I just need % differentse in third columne, but i have to calculate this third cell in row independently for each mesure.