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
Hi Mike,
What version of Crystal Reports are you using?
Go to help > about and paste the version number.
-Abhilash
Hi Abhilash,
Many thanks for your help this will be fantastic if I can get this working. Unforntunatly I have stumbled at the first hurdle.
1) While in the Preview Mode, right-click the last date and select Calculated Member > Insert Column. Do this until you see three blank columns with zero values.
While trying to do this I get an error message saying:
You have just added a calculated row/colum.
The insertion formula and the header text can be modified through the context menu of this row/colum label:
the calculation formula can be modified through the context menu of the summaries within this row/column.
PLease help..
Many thanks
MIke
Hi Abhilash,
You are an absolute star thank you so much this has worked perfectly. You have saved me a lot of work and headache.
Add a comment