1 Reply Latest reply: Jan 15, 2012 6:24 PM by jeje2011 RSS

    Hierarchy format /Pivot table prob

      Hi All:

      I am having trouble in creating a format like the following.  I am using Pivot table.

      Any help is greatly appreciated.

       

      Metric                 Curr Period     Prev Period   Diff(Prev-Curr)

      + Total Book1     1500               1200              300

           B1                   500              500                0

           B2                   500              500                0

           B3                   500              200                300

       

      + Total L1          2000               600

           L1                  500               200

           L2                  1000             200

           L3                  500              200

       

      The + symbol i am using to denote the collapse functionality.

      In the starting user will see just

      +Total Book 1          1500

      + Total L1                 2000

      But when he clicks on +, he can see/expands the details underneath each item.

       

      Also sorting is specific , it has to be B1,B2,B3.. To use specific sorting i am using Sortorder number but sort order number has to be selected in the pivot table for it to work and there is no way to hide it in the pivot table.

       

      I have tried to use Inline table to create this.Used Parent KPI and Child KPIs to get B1 under Total Book 1 etc.

      but unable to get the required format.

       

      Thanks.

        • Hierarchy format /Pivot table prob

          Hi All:

          I am having trouble in creating a format like the following.  I am using Pivot table.

          Any help is greatly appreciated.

           

          Metric                 Curr Period($)     Prev Period($)   Diff(Prev-Curr)

          + Total Book1       1500                1200                 300

               B1                   500                 500                   0

               B2                   500                 500                   0

               B3                   500                 200                  300

           

          + Total L1          2000               600

               L1                  500               200

               L2                  1000             200

               L3                  500              200

           

          The + symbol i am using to denote the collapse functionality.

          In the starting user will see just

          +Total Book 1          1500

          + Total L1                 2000

          But when he clicks on +, he can see/expands the details underneath each item.

           

          Also sorting is specific , it has to be B1,B2,B3.. To use specific sorting i am using Sortorder number but sort order number has to be selected in the pivot table for it to work and there is no way to hide it in the pivot table.

           

          I have tried to use Inline table to create this.Used Parent KPI and Child KPIs to get B1 under Total Book 1 etc.

          but unable to get the required format.

           

          Thanks.