Link to home
Start Free TrialLog in
Avatar of trilian
trilianFlag for United States of America

asked on

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%



ASKER CERTIFIED SOLUTION
Avatar of Dan Weingart
Dan Weingart
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial