Hierarchy format /Pivot table prob

[#1]

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.

[#2]

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.