Help with mapping data
I have a pivot and my pivotTableModel holds data in this fashion...
eg I have a data containing task,Year and month field values
The struture of my PivotTableModel. Below the data is being show in PivotTableModel rows...
it has theses fields
Task Year Month Values
Issued check 7 => Total checks issued
2010 4 => Total issued in 2010
Feb 3 ==> in Feb, 2011
Mar 1 ==> no of checks issued in Mar 2011
2011 3 ==> Total in 2011
Dec 3 == > issued in Dec, 2011
Now I have to show this pivot table
2011 2010 Total
Task Feb Mar Dec
Issued Checks 3 1 3 7
How to go about it?
I have a logic which tells me that user has asked for one (or more ) columns on the left and one or more columns on the top
I am havng success to show and also sort values of the left ie values of the task. but the values on the top. If single set of values I am to show. no problem, it is sorting too. but when I have more than that on the top, the top header values stop sorting and also the values against them in the table are not getting put correctly.