any possibility of sharing workbook?
Thanks for reply.
I attached 1 sample workbook, Here My scenario is regions wise 1st week total availability 19 and same like 2nd week availability 21 and 3rd week availability 11. Here I want to calculate the difference between all weeks availability, Like current week total values compared with previous week and the difference.
Please let me know How can we achieve this ?
Book3.twbx 35.2 KB
For your kind of data we will have to take the pivot by doing following. I have also attached the tableau workbook to the thread but I doubt it will work for you as it is in tableau 9.3 version.
Please follow the below steps.
Select the Week 1, week 2, week 3 and right click. This will change your data structure as below.
Then you can create the below structure using Pivot field Names(week1,week2,week3) and Pivot field values(Availability,New Hire, Nominated).
Create the structure as below.
for % Difference Right click on the Number of records and click on "Add Table Calculation"
And Do the following
You will get the required result.
Thanks and Regards,
Book3 - Output.twbx 41.1 KB
I have One doubt, When we pivot the columns our total records increased 60 to 180, Almost 3 times increased on our current records. So how can we get exact records.