<p>I have a very complicated table below that I need to implement either using table/crosstab. When I use table, I tried to make the grouping but I wan't able to do it. I thought of putting all the Usage(s) and below in footer. When I tried to do 3 sets of crosstabs (1 for Usage, 1 for Receipts, and 1 for Sources), the rows are no longer aligned. Need your advise what is the correct implementation for such table below:</p>
<p> </p>
<p>There are many cards. I need to create the same table for each card. For the Usage date, there are only 2 groups (If today is March 2013, the 2 groups will be Apr12-Mar13 and Apr13-Mar14). UsageA-E are fixed rows. For the Receipts, there are only 2 groups (last 12 months and next 12 months). RcptA-C are fixed rows and need to compute the average of them in the "Ave" row. The Tier is completely different group, it's just a Reqt/Resp columns. For the Sources, the date column can vary depending on how many dates are needed to be displayed. Item(s) will vary as well. But ScrA-F are fixed rows.</p>
<p> </p>
<p><span style="font-size:10px;"><span style="font-family:'courier new', courier, monospace;">Card1<br>
<br>
Usage | Receipts | Sources<br>
<br>
Date: | Apr12-Mar13 | Apr13-Mar14 | Period | Last12m | Next12m | Dates | 12/31/12 | 12/31/13 | 12/31/14 | 12/31/15<br>
<br>
| | | | | | Item1 | Y | N | N | Y <br>
<br>
| | | | | | Item2 | N | N | Y | Y <br>
<br>
UsageA | 12 | 10 | RcptA | 80% | 20% | SrcA | 15 | 12 | 5 | 12 <br>
<br>
UsageB | 52 | 100 | RcptB | 66% | 25% | SrcB | 12 | 10 | 4 | 12 <br>
<br>
UsageC | 24 | 42 | RcptC | 89% | 18% | SrcC | 11 | 5 | 5 | 11 <br>
<br>
UsageD | 13 | 55 | Ave | 78.33% | 21% | SrcD | 18 | 12 | 7 | 23 <br>
<br>
UsageE | 13 | 55 | Tier | Reqt | Resp | SrcE | 13 | 11 | 0 | 13 <br>
<br>
| | | | Y | N | SrcF | 22 | 19 | 9 | 16 <br>
</span></span></p>
