Hi,
I have two data sources, i have joined them in a worksheet and now want to create a hierarchy but first i have to merge 2 columns to form 1 column and then i have to create a hierarchy
Please help me in doing that.
18 answers
Hitesh,
The previous reply was for excel.
But if you are working with databases, then u will not have 'New Union' option. u will have only'New Custom SQL'. then u have to write a union query.
We have taken 'union all' because u need duplicates as per ur example. but if u don't need duplicate values then use 'union'.
From the above image u can see both rule1 and rule2 merged.
Then you can create hierarchy and add the columns which come under hierarchy.
Regards
Sunaina
