Is it possible to get cumulative percentage of a running total on a count in Crystal Reports?

Here is what I have so far:
Report Query:
Group  SELECT "Type", "H_OOS"."Lot_Number"
 FROM   "OfflineED"."dbo"."H_OOS" "H_OOS"
 WHERE  ("H_OOS"."Lot_Number">='08297' AND "H_OOS"."Lot_Number"<='09027')
 ORDER BY "H_OOS"."Type", "H_OOS"."Lot_Number"

The Lot_Number is a string, but used as a date - 090207 = Feb 7, 2009
I have a bar graph on the report with count of type  and asked to add line graph with the cumulative percentage :
Example:
Appearance
09007
09016
09021
09022
09023
Total 5
 RTotalC 5

Fill
09019
Total 1
RTotalC 6

Color
08297
09008
09008
09012
Total 4
RTotalC  10

 Create cumulative %  and graph
50%
60%
100%



LVL 1
trilianAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan WeingartAuthor / CRChartCommented:
Hi,

Sounds like you are trying to create what is known as a "pareto" graph. This graph is often used in quality-control reporting.

Pareto's are not part of standard Crystal Reports. It might be possible to "simulate" the look with clever use of overlays or other charting tricks.

If all else fails, this graph IS part of our CRChart add-in library.

-Dan

Disclaimer: I work for the company, www.threedgraphics.com, that makes this product. This product costs money.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.