Skip to Content
0
Nov 14, 2012 at 02:45 PM

Cross Tab Calculations, min,max,average

635 Views

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 60

Mike