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
Thanks
njtdAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
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.

mlmcc
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
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?
0
 
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.