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

       

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