4 Replies Latest reply on Jul 3, 2017 12:00 AM by venkat.gunda

Difference between values in same row

Toh Wangting Jun 30, 2017 2:02 AM

My data looks something like this :

Category	Sub Category	Date	Type	Amount
T1	AAA	1/1/2015	Act	1234
T1	AAA	1/1/2016	Act YTD	5678
T1	AAA	1/1/2017	Plan	9856
T2	BBB	1/1/2015	Act	4578
T2	BBB	1/1/2016	Act YTD	6325
T2	BBB	1/1/2017	Plan	7856

How do I find the difference between the values for 2016 Act YTD and 2017 Plan in % for each category?

1. Re: Difference between values in same row

Akhilesh Singh Jun 30, 2017 2:59 AM (in response to Toh Wangting)
Hello Toh,

Refer the below snapshot, if this is what you are looking for then i have attached the workbook for your better understanding.

Ak

Percentge.twbx 11.6 KB
Like Show 0 Likes(0)

Actions
2. Re: Difference between values in same row

Toh Wangting Jul 2, 2017 6:53 PM (in response to Akhilesh Singh)

Hi, the Tableau version in my work laptop now is currently an older version compared to yours so i can't view your workbook now. May i know how did you achieve the results? Is the percentage an increase/decrease from 2016 Act YTD to 2017 Plan? Thank you!
Like Show 0 Likes(0)

Actions
3. Re: Difference between values in same row

Akhilesh Singh Jul 2, 2017 9:25 PM (in response to Toh Wangting)

Which version are you using?

Create below calculated fields.

1) Act YTD = IIF([Type]='Act YTD',[Amount],0)

2) Plan = IIF([Type]='Plan',[Amount],0)

3) Percentage = LOOKUP(SUM([Act YTD]),FIRST())/LOOKUP(SUM([Plan]),1).

Use them as below snapshot.
Like Show 0 Likes(0)

Actions
4. Re: Difference between values in same row

venkat.gunda Jul 3, 2017 12:00 AM (in response to Akhilesh Singh)

pls send me the attached twbx file

Regards,
venkat
Like Show 0 Likes(0)

Actions

Tableau Community