Cumulative Totals

[ibrahim]

Hi,

Iam using "cross tab" to view the data in matrix, this report shows the data product wise sales as column group and row group as month. Every month has some of amount and sales and number of sales which iam displaying in different columns. How can i get the cumulative sales totals amount and number of sales. Please see the example below

Products          X                                 Y                      Z
July                 200                              300                   400
August            400*(200+200)             700(300+400)    650(400+250)
                    

For example for product X (I need 400 as total in the month of August which include 200 which is july sales)

Please help.  

[Svetoslav]

Hello ibrahim,

Even though the Table (and Telerik Reporting at all) item lacks the capability to calculate running totals, you can easily achieve a similar result. Please see the attached report that uses the ProductSalesDataSet from the Telerik Reporting's sample ReportLibrary to illustrate one possible solution. Since the processing Table is generated by rows, you can accumulate the values by columns in a Dictionary object.

I hope this helps.


Best wishes,
Svetoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Nurali]

Hi,
Is there a similar workaround for Chart's. Chart has a datasource instead dataobject property .Ok. Then ?

[Stef]

Hello Nurali,

With proper data organization it can be shown in a Graph item. For example, please check the attached XML report definition demonstrating running aggregates in both Crosstab and Graph.

If you need further help, please elaborate on your scenario, data structure, need accumulations and desired layout.

Regards,
Stef
Telerik