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
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
0
KS
Top achievements
Rank 1
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
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
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
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
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. :)
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. :)