An alternative to the algorithm for computing axes values is, as Al suggests, a way of annotating headers with information that indicates which cells they apply to. I have experimented with a simple way to achieve this using a "scope" attribute. The scope attribute can be used with TD and TH elements. Its permitted values are: row all cells in the row column (or col) all cells in the column rowgroup all cells in the same row group colgroup all cells in the same column group column groups are marked up using the COLGROUP element. row groups are marked up using THEAD, TFOOT and TBODY elements.
Here is the table markup for the example show in the attached image:
Meals | Hotels | Transport | subtotal | |
---|---|---|---|---|
San Jose | ||||
25-Aug-97 | 37.74 | 12.00 | 45.00 | |
26-Aug-97 | 27.28 | 112.00 | 45.00 | |
subtotal | 65.02 | 224.00 | 90.00 | 379.02 |
Seattle | ||||
27-Aug-97 | 96.25 | 109.00 | 36.00 | |
28-Aug-97 | 35.00 | 109.00 | 36.00 | |
subtotal | 131.25 | 218.00 | 72.00 | 421.25 |
Totals | 196.27 | 442.00 | 162.00 | 800.27 |