Crystal Crosstab percentage of summded values

I am trying to create a crosstab report in crystal that will calculate the percentage between summed values that are  grouped/totaled by month, qtr and year. If I use the weighted average feature the percentage value by month is close but not exact. The values calculated for qtr and year are completely incorrect. I have done this exact calculation in an OWC pivot table using the "calculated totals" feature and the result are exactly what I am looking for. Only problem with the OWC Pivot Table is that the summed values are aligned horizontally and I need them vertically. The Crystal Crosstab control gives me the presentation exactly as I need but the percentage calculations is an issue. Any suggestions. I have crystal xi with a sql2000 backend.

guillorytAsked:
Who is Participating?
 
MIKEConnect With a Mentor Software Solutions ConsultantCommented:
QuilloryT:

I hope I'm understanding, ....have you tried to add another SUM field..but change the SUMMARY to SHOW AS A PERCENTAE OF "column"?

MikeV
0
 
guillorytAuthor Commented:
MikeV

   The percentage needs to be the difference between two seperate summed values not the percentage of the running total of a column or row.

Thanks
0
 
MIKESoftware Solutions ConsultantCommented:
Pls post example, my first inclination is that you'll need to do a "manual crosstab" using variables to carry the totals.

Show me a simple example of your final crosstab data.

Thanks
MikeV
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.