If you have the hierarchy in your data then Tableau will understand. If you have to, drag the dimensions on top of each other in the dimensions area and it will form the hierarchy.
The Tableau sample data has some examples as well.
The following example shows how to create Hierarchies in Tableau.
Creating Semester Level in the Date Hierarchy.
1) Create Calculations Using the Date Functions.
2) Similarly Create Month, Date Calculations.
3) Crate Semester using the Syntax which was used in the below Image.
4) Create Another Calculated field for Date.
5) Drag Year, Month Fields from Measures Window to Dimensions Window.
6) Create a Hierarchy by right click on "Year" field.
7) Drag the Semester, Month, Date1 Fields into the Hierarchy or Right click on these fields , Choose Add to Hierarchy.
9) Arrange the Level From Top to Bottom Accordingly by dragging & dropping. (Year -> Semester -> Month -> Date1)
10) Now we are having the Time Dimension With New Level "Semester".
11) We can find the Hierarchical Relationship.
but this is not what I am looking for. Once you will click Plus, everything is available, I would like to see only those child which are under particular parent
It may be useful for you, Apply filter on parent, then click on that parent to get it's children.
This is the only solution I can find for right now
Did you find any alternative way apart from the above posts?
To be able to use a "partial member" drill-down / rollup
one should have them pre-defined in a cube hierarchy.
So one need to build a cube with the data
(for example MS SSAS or Oracle Essbase)
and browse (MDX-query) it with Tableau.
When using file or SQL sources, hierarchies open in full.
PS There is a nice summary comparing SQL and MDX datasources:
I have hierarchy in database (A), but when I connect data (A) how can get hierarchy from this data by tableau!!
(sorry about my english)