1 of 1 people found this helpful
Hope you are doing well !
with refrence to Hirearchy, we need to create hirearchy in Diamension level.
Once we have hirearchy we tableau itself facilatate + and - sign i.e drill up and drill down.
For example :
I have we have product hirearchy which contains below child :
Each child have mulitiple child and so on.
In dashboard drag Product and you can see plus sign in front of diamension as below :
Thanks a lot for your quick answer. Actually your example is exactly what I want.
However, I don't really understand how you build your datamodel. Could you please reply with a screenshot of your database / explain further what you mean by creating a hierarchy in dimensional level?
Also, don't you think it is possible to have exactly the same result with a Starschema model?
Thank you very much in advance,
Have a good day
You can create hirearchies as below :
Based on above data we will create hirearchy on three fields.
Select Sub Category New and drag over to Category New.
The moment you drag and drop over Category new new popup will appear as belwo :
Name it to your hirearchy
Once you click on Ok, your hirearchy will be created as below:
Repet this step for Product name new as well.
You can change order of diamension by select and move your diamension where you want.
It is very clear. Thanks a lot for your help!