Hi,<br />
<br />
I'm trying to build a crosstab that displays multiple groups from a data cube, all crossed with the same dimension. I can do this now, but I need to define multiple crosstabs. I wonder if there's an easier way.<br />
<br />
The use-case: cross "Age" w/ "Gender", "Income" w/ "Gender" and present like so:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
| | MALE | FEMALE | Total |
| Age | | | |
| 18-34 | | | |
| ... | | | |
| Total | | | |
| Income| | | |
| 0-10K | | | |
| ... | | | |
| Total | | | |
</pre>
<br />
My cube has all three dimensions (age, income and gender). This table provides a summary of multiple dimensions crossed against a common one...<br />
<br />
Is this doable or do I need to make multiple crosstabs? If I need to make multiple crosstabs, what is the best way to "hide" the header of subsequent ones?<br />
<br />
Thanks,<br />
Philippe
