Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how can I group all the dimension columns in a single column with same type of group.
Create Groups on the Groups tab of the Document Properties window. Use the Groups as dimensions in your charts.
I have tried but it is not like that as I want , I want hierarchy in a single column in pivot table .
Please see the screenshot.
Enable the Indent option on the Presentation tab. If that also is not what you want then you're out of luck.
so it is possible in pivot or straight table.
?
You should be able to do it using standard pivot functionality, can you post a sample of your data / qvw?
Andy