Jesus, you made that easy. Had already read like a dozen help articles that just confused the issue more, and you solved it in the first 2 mins of your video. THANK YOU
Hi Andy, thank you for explaining it so clearly. I got stuck at 3:03 as i simply dragged the sum of sales vs using crtl+drag - Tableau returned a different layout than yours (got it sorted in the end). Could you clarify what does using ctrl when dragging change please?
Hi, super helpful video. Can we do a nested sort + ranked sort in the same worksheet? So, essentially trying to sort a table using 2 dimensions and 1 measure
Great content. I have a similar data and am trying to move region to "pages" so that it only shows one region at a time and user can use tool on the right side to select which region they want to look at. But when I move region to pages, the bars are not sorted properly. Do you have a video or suggestion how to do that?
But if we have hierarchy in the view and when we drill thru to next level in this case from subcategory to product name, then Rank method is not working as expected and also with combined field method we are not getting grouping of left data items properly. Please suggest the approach if we have hierarchy in the view and if we drill thru to next level it has to be sorted automatically . Thanks
I have three fields , date, state and sum(sales). I have to pick top 5 States (based on sales) for current quarter and get trend graph for those states in past three quarters. How can I do this?
Nested Sorting worked fine but after that I'm not able to show the values of the SUM(SALES) i.e., Label option is not working afterwards. Can anyone help?
Jesus, you made that easy. Had already read like a dozen help articles that just confused the issue more, and you solved it in the first 2 mins of your video. THANK YOU
Andy, you are a life saver. Here I am trying to mess with context filters when it really came down to rank! Thank you!
Happy to help!
Awesome. Your videos are evergreen. Helping users like me even after 3 years.
Outstanding video. This has been giving my team a huge amount of trouble. Thank you!
Nice work Mate - Now I understand the approach of using nested sort and rank sort. Thanks
This answered a problem that I had for sooo long! Thank you very much.
Hi Andy, thank you for explaining it so clearly. I got stuck at 3:03 as i simply dragged the sum of sales vs using crtl+drag - Tableau returned a different layout than yours (got it sorted in the end). Could you clarify what does using ctrl when dragging change please?
Very quick and great explanation. Thanks for the upload.
Hi, super helpful video. Can we do a nested sort + ranked sort in the same worksheet? So, essentially trying to sort a table using 2 dimensions and 1 measure
Very useful. Thanks. How do I display the first 10 categories within each region? Thanks
I would use a RANK table calc, set it up to compute for each region, then filter the rank to 1-10.
Great content. I have a similar data and am trying to move region to "pages" so that it only shows one region at a time and user can use tool on the right side to select which region they want to look at. But when I move region to pages, the bars are not sorted properly. Do you have a video or suggestion how to do that?
I would use region as a filter not on pages.
Thank you Andy. You Saved my day!
Hi Andy, What if I don't want to put Region as column but use as a filter. How can I achieve that?
Amazing. Would the option 2 (rank) also work if I start applying some filters? Cheers
Yes, the filters apply before the rank is calculated.
But if we have hierarchy in the view and when we drill thru to next level in this case from subcategory to product name, then Rank method is not working as expected and also with combined field method we are not getting grouping of left data items properly. Please suggest the approach if we have hierarchy in the view and if we drill thru to next level it has to be sorted automatically . Thanks
This is a great video.
Very well explained.
Thanks so much.
Table calculations are simultaneously powerful, mysterious, and infuriating in about equal measures, until you get the hang of them. Nice video.
sorry, for the combined field, why do I have to drag it in between the category and subcategory? why if I put it after subcategory does not work?
nice addition of the top n filter
Incredibly helpful video. Love the ability to rank.
Thanks for the video - helped me sort on dates. Did the nested trick
How to bring regions into column and do the same thing ?
Hi Andy .. How can I sort colours Biggest to smallest -Stack Bar chart.. It would be really helpful if you kindly publish a tutorial for that
I have three fields , date, state and sum(sales). I have to pick top 5 States (based on sales) for current quarter and get trend graph for those states in past three quarters. How can I do this?
Nice Explanation Andy and its not frustrating :)
I have a very similar example but there is a small change, lets say wanted to do this but using dimension as hierarchies.
Thank you so much - this was incredibly helpful. Really like the rank sort!
Nested Sorting worked fine but after that I'm not able to show the values of the SUM(SALES) i.e., Label option is not working afterwards. Can anyone help?
This was extremely helpful, thanks!
Thank you, this helped greatly!
Thanks for sharing! This was exactly what I was looking for! :)
Great... Super.. This is really awesome.
Thanks a lot for helping me....................
Many thanks...
Works for me. Thank Youuuuu!!!! :)
What if rank is same for more than one sub-category??
Brillaint thankyou
wondering why it is not easy for tableau to implement sorting on measures as columns. rotfl