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.