Pivoted number drill down values on fly to level 1,2,3,4

[vinay_hg]

Hi all,

we have a requirement of Pivot table download to excel, where for eg:

i have a pivot of

dimensions : Region manager, territory manager, sales rep, Country, State, sales phases, opportunity

measure:

Sales number

Delivery number

difference

now, customer want to download report at

regional manager level

regional,territory manager level

regional,territory, & sales rep wise to excel.. but we have 6 region, 40 territory & 600 sales reps etc.

they have to click one by one to expand and at that level to download from pivot..

how to expand all item to download at level 1 - region report, level 2 territory, level 3 sales reps etc.. (as pivot will download the report as is what you see on screen)

please help..

[vinay_hg]

pls help..