Hi All,
I am trying to create a cross tab report showing sales via product via day of week. I have managed to do this but would like to add some further calculations to my cross tab report Average, Min and Max. It it possible to do this in a as calculation in the cross tab report. Many thanks for any advise and guidence given.
Stock FRI 01/01/2012 FRI 08/01/2012 FRI 16/01/2012 TOTAL Average Min Max 1 Pint Whole 100 80 60 210 80 60 100 1 Pint Semi 200 250 300 750 250 200 300 1 PInt Skimmed 60 50 40 150 50 40 60Mike