Hi All,
I have a list report with fields as branch,lob,year and some facts.
Branch,lob and year are grouped fields.my requirement is to show data as total for all levels but for the last summary line it should show the average value of all the summing values.
Can anyone pls help me??
Quote from: sasmitash26 on 04 Apr 2016 07:44:53 AM
Hi All,
I have a list report with fields as branch,lob,year and some facts.
Branch,lob and year are grouped fields.my requirement is to show data as total for all levels but for the last summary line it should show the average value of all the summing values.
Can anyone pls help me??
Hi,
You can do this by adding query calculations in the final footer. The one for the Branch average would be:
total([your measure] for report) / count([your Branch item])
Cheers!
MF.
Thank you MF for the solution.😊 But I have 2 more facts for which the summary line should be a sum value .only for one fact they need average at the footer..is it possible..
You can total the fields as usual, then unlock your report to delete the total for the measure that you want the average for. Then in the place where the total used to be you can bring in a query calculation and put in the expression that MF gave you.