1 Reply Latest reply: Jan 12, 2017 4:32 AM by vinaykumar HG RSS

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

    vinaykumar 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



      Sales number

      Delivery number



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