Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

Crystal Report 8.5 accumulate summary problem.

I want to create report like this

A1                        A1/(A1+A2+A3+A...)
A2                        (A1+A2)/(A1+A2+A3+A...)
A3                        (A1+A2+A3)/(A1+A2+A3+A...)

how to write the formula to make report like this
1 Solution
Kurt ReinhardtCommented:
What is the significance of each row - are they groups or detailed records?  Also, it looks like you want to divide by the sum of all rows, is that correct?
njtdAuthor Commented:
I want to know the number of product that generate total revenue 60%

ProductA         TotalSaleOfProductA           %SaleProductA of TotalSale
ProductB         TotalSaleOfProductB           %SaleProductA+B of TotalSale
ProductC         TotalSaleOfProductC           %SaleProductA+B+C of TotalSale
ProductZ         TotalSaleOfProductZ            %100
One way would be to group the data
Group on the Product
You can then use summaries to get the totals and the % of total sales.

It seems you also want a running total percent of all sales
You should be able to do that with the running total or with formulas and variables.


Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now