Hessel de Walle's Blog

Based on the tables Categories , Order_Details , Orders and Products from the Northwind database I created this example of a Pareto Analysis, the best I could get so far: To get the percentage I first created a Running Total {#PercentageCum}on the field  Order_Details.ProductID.  Then I created a Formula Field Percentage : {#PercentageCum}/Count ({Order_Details.ProductID})*100 This field I used in the report. The initial column graph is based on change of Categories.CategorieName. Values : Count of Order_Details.ProductId #PercentageCum I linked the second series to the second Y-axis. For this series I chose line graph instead of column and gave it the color red. I turned the secondary Y-axis off (you can not use the field Percentage in the graph; so you can not show the real percentage on the Y-axis: Crystal Reports doesn't allow charts to use formulas that refer to running totals). You can download the file here: www.walmar.nl/zips/GraphPareto....