Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Charting values based on group formula

Status
Not open for further replies.
Dec 18, 2006
69
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top