Crystal Report 8.5 accumulate summary problem.

Posted on 2008-11-03
Last Modified: 2012-08-14
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
Question by:njtd
    LVL 26

    Expert Comment

    by:Kurt Reinhardt
    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?

    Author Comment

    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
    LVL 100

    Accepted Solution

    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now