I have a list , with multiple facts within a column cell by unlocking and using blocks to insert other metrics.
Eg:-
Dpt | Vendor | Day TY | Day LY
______________________
Dpt1 |Vendor 1| #Cost | #Cst
|#Rtl | #Rtl
|Vendor2 |#Cost | #Cst
|#Rtl | #Rtl
Dpt2 |Vendor 1| #Cost | #Cst
|#Rtl | #Rtl
|Vendor2 |#Cost | #Cst
|#Rtl | #Rtl
How can i insert a summary row after each Department , that should consist of summary for both the facts [ cst/rtl ] and for both DayTY,DayLY
so final list should be llike
Dpt | Vendor | Day TY | Day LY
______________________
Dpt1 |Vendor 1| #Cost | #Cst
|#Rtl | #Rtl
Vendor2 |#RTL | #RTL
|#CST | #CST
Agg. +Rtl | +RTL
+cst | +cst
Dpt2 |Vendor 1| #Cost | #Cst
|#Rtl | #Rtl
|Vendor2 |#Cost | #Cst
|#Rtl | #Rtl
Agg. | +Rtl | +RTL
| +cst | +cst
_________________________
TOTAL | +Rtl | +RTL
| +cst | +cst
How can we achieve this ?
Thanks !!
Group your report on Dpt, then select Day Ty and Day LY and use the Aggregate button (on the toolbar) to add a summary for these.
Once you have the summary footer row after each Dpt, unlock your structure and add query calcs to display the totals - eg total([Cost] for [Dpt])
Cheers!
MF.