I get data as below from dataset
Year custname custnum Jan feb Mar Apr May Jun
2013 ABC Ability 000104 199145 9299 1496 0 0 0
2012 ABC Ability 000104 202940 10477 0 0 0 0
2013 XYZ Receiv 000110 81499 66667 94915 236830 102533 69619
2012 XYZ Receiv 000110 136948 94051 84563 69581 73565 68922
2013 PQR Recoveries 000644 213872 172285 224032 227751 254794 212183
2012 PQR Recoveries 000644 247707 253114 302022 286795 327772 300033
I want to my report look like as
Customer Jan feb mar jan apr may Jun
ABC Ability 199145 9299 14960 0 0 0
000104 000104 202940 10477 0 0 0 0
and so on for next customers and at the end the totals for each month different for each year
Update
I got the the data representing as required now only stuck at the totals
I want the totals sepratly for each year basis
That is at the end it should look like
Total this row will contain total for 2013 for each column
this row will contain total for 2012 for each column
so i need to filter the dataset for yearly basis and get the total but don't know how any help would be great
Try this solution:
In design mode your report should look like this: