lcallah93
asked on
Crystal Reports Chart - percentage of total
This seems like a really simple problem, but those are the ones I can NEVER figure out.
I have created a report that itemizes donations collected towards an overall goal. What I want to do is insert a chart that shows how much money we have received as a percentage of the goal. For example, we have received $75,000 so far towards the goal of $425,000. I would like the chart to show those two figures. I have formulas that show each figure and they are located in Group Footer 1. I put the chart in the report footer.
Any help would be apprecaited!
I have created a report that itemizes donations collected towards an overall goal. What I want to do is insert a chart that shows how much money we have received as a percentage of the goal. For example, we have received $75,000 so far towards the goal of $425,000. I would like the chart to show those two figures. I have formulas that show each figure and they are located in Group Footer 1. I put the chart in the report footer.
Any help would be apprecaited!
ASKER
I got the first part - the summary of the gifts - but how did you add the goal? I see some command fields in your report - do I need to do something with that? I created a formula and put the result in the footer (Challenge Grant Goal - Total Committed) but when I add that formula to the "show values" box it is blank.
I just used the commands to put your example data in a report.
Can you attach your report with data saved?
Also, is the goal stored in your database somewhere, or is it just something you know and are hardcoding against?
Can you attach your report with data saved?
Also, is the goal stored in your database somewhere, or is it just something you know and are hardcoding against?
ASKER
I have attached the report. The goal is hard-coded in the report.
Science-Lab-Challenge.rpt
Science-Lab-Challenge.rpt
ASKER
The goal is not hard-coded, sorry, it's determined by a formula.
Okay - see attached. It looks like it is working the way you need it.
Lin-Science-Lab-Challenge.rpt
Lin-Science-Lab-Challenge.rpt
ASKER
It looks good - what did you do? I cannot access the "set summary operation" button in chart expert under the data tab. Your report has Sum of @ Total Committed and Sum of @ Left udner "Show values". Mine has Sum of @ Left but I think it's not the same as your value. I also do not see how to get the Sum of @ Total Committed value.
I am not afraid to say that charting in Crystal has me confused...
I am not afraid to say that charting in Crystal has me confused...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
EE.rpt