Hi,
I have a scenario in which there is one hierarchy (row) with multiple levels and one key figure. Now i want to have a pivot table with hierarchy as selection option (i.e i can drill down using hierarchy levels).
How can i do the same.
I am able to get a pivot table, but it shows all the hierarchy elements as flat file, i want to have hierachy levels in pivot table.
please help.
cheers
rajiv
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.