Hierarchy levels and pivot table

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