Thanks a lot but what if the data source is database. The pivot option disappeared. I tried with excel it's clear and working well. Would you please How we can solve this problem? Thanks in advance for anyone support. 😊
Thanks for the vid! I understand this part. I have some new data that I need to add in though. So in my Excel file, I have columns for each year with values for each of my rows. So I pivoted this inititally. But now I have a new year. The option to add to pivot is there - but the column with my pivot field values totally disappeared. And I can't see my data after that. And I have a second year I want to add also, but after pivoting the first one, the second one doesn't have an option to pivot... any idea what I need to do differently?
I am having a similar dataset, but with loads of rows before pivot. In this case that would mean that several rows would contain boxing for example. When I pivot the data and aggregate the results the sums, average, and counts are not equal to before the pivot. Do you know why this happens?
Hi there. How would you add a new sport to the pivot if your base table data changes and include a new sport? I am stuck currently as I can’t see the Add Data to Pivot option anymore. Hope you can help. Btw....a really nice and simple video to follow.
If a new sport was added to the base table, it would show up in the data (assuming you were still connected to the same table). Since sport is in a single column before the pivot, a new sport would show up as a new row in the sport column, and all it's metrics would be pivoted. If a new metric was added to the data, that would be a new column, and we'd have to create the pivot.
@@SarahWilsonmeow you'll have to go back and recreate the pivot from scratch I think, so un-pivot the existing columns, then re-create the pivot with the new columns.
May keep on pressing Ctrl+Z until the point to start all over again. Else on the Tableau worksheet, right-click on the data source & click on "Close" & start all over again.
What if I don't see the Pivot option in the menu?
I can’t believe that i used to do that manually, thanks!
Such a good video! Thank You!
a life saver
Thanks a lot but what if the data source is database. The pivot option disappeared. I tried with excel it's clear and working well.
Would you please How we can solve this problem?
Thanks in advance for anyone support. 😊
Sadly, i'm on version 2018.1, which doesn't make this available to me
Thanks for the vid! I understand this part. I have some new data that I need to add in though. So in my Excel file, I have columns for each year with values for each of my rows. So I pivoted this inititally. But now I have a new year. The option to add to pivot is there - but the column with my pivot field values totally disappeared. And I can't see my data after that. And I have a second year I want to add also, but after pivoting the first one, the second one doesn't have an option to pivot... any idea what I need to do differently?
Thanks for video!.. but I am unable to get Pivot option after I do right click, could you please help?? Tableau 2020.3.1
No link for the data set given to download. Although searched & got the same from elsewhere online ;-)
I am having a similar dataset, but with loads of rows before pivot. In this case that would mean that several rows would contain boxing for example. When I pivot the data and aggregate the results the sums, average, and counts are not equal to before the pivot. Do you know why this happens?
Hi there. How would you add a new sport to the pivot if your base table data changes and include a new sport? I am stuck currently as I can’t see the Add Data to Pivot option anymore. Hope you can help. Btw....a really nice and simple video to follow.
If a new sport was added to the base table, it would show up in the data (assuming you were still connected to the same table). Since sport is in a single column before the pivot, a new sport would show up as a new row in the sport column, and all it's metrics would be pivoted. If a new metric was added to the data, that would be a new column, and we'd have to create the pivot.
@@penguinanalytics1984 Hello! I have a new column to add into an existing pivot. How would you approach this scenario?
@@SarahWilsonmeow you'll have to go back and recreate the pivot from scratch I think, so un-pivot the existing columns, then re-create the pivot with the new columns.
@@SarahWilsonmeow you can add that column in pivot by option "add data to pivot"
How can I create a seperate pivot "table"?
Isn't it really unpivoting?
Yeah, technically it is, but Tableau named it the pivot function, so thats what I went with! :)
That's 3 min.
just joking, thanks for the video! :)
How do you deal with the duplicate data after pivoting? Thanks
you need to create a calculated field or check off aggregate under analysis depending exactly what you're trying to do
LOD calculations help here
Now how can I visualise the difference in average wages of men and women?
I want to unpivot again to get column how we can do it
May keep on pressing Ctrl+Z until the point to start all over again. Else on the Tableau worksheet, right-click on the data source & click on "Close" & start all over again.
Please share the datasets