TryingToLearn101
MIS
Hi all,
I am working on Crystal 2008.
My fields from the database are:
Order No
Order Date
Order Line Count
Invoice Line Count
I grouped my report by order date as group 1 and set it to show by week. I also created a formula to show sum invoice line count by week / sum order line count by week * 100 to get the percentage. I then placed the @percentage field to group 1 header. Everything looks great until I get to the chart.
How can I chart the percentage value based on the week group I specified? The chart only allows me to do this by the detail info which is the order date.
I hope I explained it clearly enough. Please advise.
Thank you in advance,
TTL101
I am working on Crystal 2008.
My fields from the database are:
Order No
Order Date
Order Line Count
Invoice Line Count
I grouped my report by order date as group 1 and set it to show by week. I also created a formula to show sum invoice line count by week / sum order line count by week * 100 to get the percentage. I then placed the @percentage field to group 1 header. Everything looks great until I get to the chart.
How can I chart the percentage value based on the week group I specified? The chart only allows me to do this by the detail info which is the order date.
I hope I explained it clearly enough. Please advise.
Thank you in advance,
TTL101