Discovere Calculated Totals
710539Jul 8 2009 — edited Jul 10 2009Hello all:
I need to build a cross tab report with totals to the right of the report for the data points, the problem is that these total needs to be averages and weighted averages, so if you have 100 bottles done out of 200 for some month this will be 50% for that month and if you have 500 out of 2000 done for another month then this is 25% for the this month but the average that will show against the percentage completed will be 50+20/2 = 35% but what I want is 100+500/(200+2000) = 27.27% can this be done for the totals some how or if there is any other way of doing it to be displayed as a total ( the report has to be cross tab).
Thanks a lot
Khaled Jamoos