Nice and very useful one; but is that possible (in this case) Sub category should not open in separate column but underneath of Category with some indentation ? Thanks
Hi Thats a great question. You can do it the same way by creating multiple calculations and multiple sets for individual layer. Please try and let me know incase of any issues.
Hi Piyush, that a great question. If you need 3 levels of drill down then you need to create a similar calculation for third layer if [set1] and [set2] then [Product] else ' ' end Hope that helps:-)
Thanks for this useful video.I tried the same thing and able to do 4th level drill down as well but i stucked when doing totals and subtotals because this is showing outside the hierarchy actually that totals and subtotals should be shown while we do drill down but it is present as static field do you have any solution on this it will be helpful for me
Nice work! I haven't tried adding totals using multi level drill down but logically if you use windows calculation then it will add the total for that section. Please try that and let me know if it still doesnt work then i will give it a go. Cheers! Gurpreet
Nice work! I haven't tried adding totals using multi level drill down but logically if you use windows calculation then it will add the total for that section. Please try that and let me know if it still doesnt work then i will give it a go. Cheers! Gurpreet
Hi Ajinkya, you can create as many layers of drill down you want using same technique. you just need to create more calculations the ways you used it for first layer of drill down. Please try that and let me know if you need any help. Cheers!
Hi Nama, It will work the same way in Tableau 2020.2 as well. You can download this dashboard from the link in description of this video and try it on tableau 2020.2
Nice one sir, I could do it before watching the entire video because of the well explained videos you made earlier on set & actions.
That’s great. Glad you are enjoying it. Keep up the good work and share it with community 👍
Great! how can I add totals when I do the split? I need to show the total of the category and the detail. Thank you!
this was an excellent video! thank you and just subscribed to your channel!
Thanks Dan for your feedback and for supporting my channel 🙂. Stay tuned for more such videos.
Cheers!
Nice and very useful one; but is that possible (in this case) Sub category should not open in separate column but underneath of Category with some indentation ? Thanks
Hi , impressed,
I need multiple 4 layer dill down and drop down as you had just one level, how can we do accomplish that. Kindly help
Thank you.
Hi Thats a great question.
You can do it the same way by creating multiple calculations and multiple sets for individual layer. Please try and let me know incase of any issues.
How to do like this +Category
Books
Mobiles
Music
under this I should get all the sub cat values like above mentioned so can u help me on that
What about sub categories leading to let's say product.. how do we get that
Hi Piyush, that a great question.
If you need 3 levels of drill down then you need to create a similar calculation for third layer
if [set1] and [set2] then [Product]
else ' '
end
Hope that helps:-)
Little tricky to do but got it working
@@LokeshS-nz4ti great work :-) Please do share your work with Tableau community as well. Cheers!
@@LokeshS-nz4ti Hi lokesh, I am unable to drill it to the third level. Could you please help me with this?
Indeed an excellent video
Thanks Harish. Stay tuned for more such videos and thanks for supporting my channel. Cheers!
Gurpreet
Thanks for this useful video.I tried the same thing and able to do 4th level drill down as well but i stucked when doing totals and subtotals because this is showing outside the hierarchy actually that totals and subtotals should be shown while we do drill down but it is present as static field do you have any solution on this it will be helpful for me
Nice work!
I haven't tried adding totals using multi level drill down but logically if you use windows calculation then it will add the total for that section. Please try that and let me know if it still doesnt work then i will give it a go.
Cheers!
Gurpreet
Nice work!
I haven't tried adding totals using multi level drill down but logically if you use windows calculation then it will add the total for that section. Please try that and let me know if it still doesnt work then i will give it a go.
Cheers!
Gurpreet
Thank you for the demo, how can we expand two categories at the same time?
Hi Antonio,
You can do the same way by creating multiple calculation and same logic.
Please try that and let me know in case of any issues.
Cheers!
Amazing!
Thanks 🙏🏽 Wendy
How to proceed further to drilldown por let say product after subcategories? Please give me some explanation?
Hi Ajinkya, you can create as many layers of drill down you want using same technique. you just need to create more calculations the ways you used it for first layer of drill down. Please try that and let me know if you need any help. Cheers!
Thanks for uploading, its nice video. May i know how to achieve this in 2020.2 version.
Hi Nama, It will work the same way in Tableau 2020.2 as well. You can download this dashboard from the link in description of this video and try it on tableau 2020.2