This is a migrated thread and some comments may be shown as answers.
Cumulative Totals
3 Answers 135 Views
This is a migrated thread and some comments may be shown as answers.
ibrahim
Top achievements
Rank 1
ibrahim asked on 08 Jun 2009, 02:38 PM
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.  

3 Answers, 1 is accepted

Sort by
0
Svetoslav
Telerik team
answered on 09 Jun 2009, 05:11 PM
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.
0
Nurali
Top achievements
Rank 1
answered on 13 Jun 2013, 01:06 PM
Hi,
Is there a similar workaround for Chart's. Chart has a datasource instead dataobject property .Ok. Then ?
0
Stef
Telerik team
answered on 18 Jun 2013, 10:50 AM
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

Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

Asked by
ibrahim
Top achievements
Rank 1
Answers by
Svetoslav
Telerik team
Nurali
Top achievements
Rank 1
Stef
Telerik team
Share this question
or