This is a migrated thread and some comments may be shown as answers.

Combining Results from two CrossTabs

3 Answers 80 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Brett
Top achievements
Rank 1
Brett asked on 04 Jun 2013, 02:42 PM
Hi,

My report has a dataset that lists data values by account and period.
e.g.
Account Period1 Period2 Period3
Sales A 100 200 200
Sales B 50 50 140
Costs A 50  50 100
Costs B 25 30 40


from this data I have two cross tabs - each one filters on a particular 'recordtype' field that defines whether its a sale or expense.
So the first crosstab shows (and totals) all the sales by account and period, and the second crosstab shows all the expenses by account and period.

What I now need is another table or cross tab (preferably that will line up) that will show the difference between the sales and costs - thus getting a rudimentary profit, and then another row that shows the margin as a percentage.

Please can you help?

Regards

3 Answers, 1 is accepted

Sort by
0
KS
Top achievements
Rank 1
answered on 07 Jun 2013, 05:05 PM
Hi,

Organize your data and create a single crosstab for everything. Just define different row groups for expenses and sales, and add totals with the needed calculations.- http://demos.telerik.com/reporting/product-sales/demo.aspx
0
Brett
Top achievements
Rank 1
answered on 10 Jun 2013, 09:09 AM
Hi,

OK thanks - I got that working as suggested.

However, I could do with an empty row between the row groups - is that possible?

Regards
0
KS
Top achievements
Rank 1
answered on 13 Jun 2013, 09:10 AM
Hi,

I think it is possible. Add some parent group, static row in the sub group - the actual displayed part of the crosstab, and hide the added parent group column. :)
Tags
General Discussions
Asked by
Brett
Top achievements
Rank 1
Answers by
KS
Top achievements
Rank 1
Brett
Top achievements
Rank 1
Share this question
or