# 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
###### Who is Participating?

x
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.

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
Author 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
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

Experts Exchange Solution brought to you by