I need to present pivoted data in a manner similar to this:
_________________________________________________________
_________|2008_______________________|2009_______________________|
|Region__|Q1____|Q2____|Q3____|Q4____|Q1____|Q2____|Q3____|Q4____|
|North___|__1234|__5678|__1234|__5678|__1234|__5678|__1234|__5678|
|East____|___929|___829|___789|___934|__1200|__1450|__1400|__1198|
|West____|__4444|__5555|__6666|__7777|__8888|__9999|__9999|__9999|
|South___|__3456|__2345|__6789|__3456|__2352|__5464|__3426|__9837|
There may be any number of sub groups in columns and rows, for example:
____________________________________________________________
________|2008_______________________________________________________|
|Region_|Q1____________|Q2____________|Q3____________|Q4____________|
|_______|Jan_|Feb_|Mar_|Apr_|May_|Jun_|Jul_|Aug_|Sep_|Oct_|Nov_|Dec_|
|North__|_123|_568|_124|_568|__92|_829|_124|_568|_124|_568|__99|_829|
and:
_________________________________________________________
________________|2008_______________________|2009_______________________|
|Region__|State_|Q1____|Q2____|Q3____|Q4____|Q1____|Q2____|Q3____|Q4____|
|North |MI____|__1234|__5678|__1234|__5678|__1234|__5678|__1234|__5678|
| |OH____|__4444|__5555|__6666|__7777|__8888|__9999|__9999|__9999|
|________|IN____|__3456|__2345|__6789|__3456|__2352|__5464|__3426|__9837|
|East |NY____|__1234|__5678|__1234|__5678|__1234|__5678|__1234|__5678|
| |PA____|___929|___829|___789|___934|__1200|__1450|__1400|__1198|
Or any combination thereof. I need to be able to add extra row headers and set
colspan and also set rowspan and make the rows color scheme match the header.
I started writing a subclass of Table, but then I figured someone out there
has probably already done this. Anyone?
