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
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)