But actually I have a requirement for this which is still in process and I'm asking this because if it can work in pivot then I'll go for it or else I have to seek for a alternative . Like tree view in a list box and the remaining separately in another box/table & On what type of data it is gonna works ( I mean recursive or flattened data )
So if you don't mind can u share ur idea in what case that the tree view in pivot is gonna work.
Since it is not clear what your raw data looks like, it is a bit tricky to give a good answer on how hard work you will have to accomplish what you want to do. My recommendatyion is that you try to make a sample data basedon what you know about your data sources, so that you can make a conformance test of how the data can be handled.
See my attached sample of an autogenerated hierarchy, to give a indication of what a the pivot table projection could look like. Hope it can be helpful.