Hi
Is it possible to create Temp table according to Pivot output dynamically & show Grand Total
Below is the output from Pivot. Item can be upto n levels like Item1 , Item2 , Item3, Item4
Name Item1 Item2 Loc-1 1 1 Loc-2 2 Null
Thanks