0 Replies Latest reply: Mar 3, 2013 6:22 PM by Krishna Choudhary RSS

    Multiple Hierarchy pivot table

      Looking to set up hierarchies in the below format on the X-axis and Y-axis in a pivot table, can you give me any idea how to proceed?

      Have bought my hierarchies into the table but not sure how to set them up on Business line with drilldown for both the hierarchies.

       

      Appreciate any ideas you can ptich in.

       

      Thanks

       

       

      Header 1Header 2Header 3Header 4Header 5Header 6Header 8
        Business    ABC
      FGH
      MNO

      BC
      GH
      NO

      C
      H
      O

      salespredictionssalespredictionssales predictions
      Accounts





      wxyz





      xyz





      yz





      z





      ghjk





      hjk





      jk





      k