Formatting table woe

[Guest_imported]

Greetings,
I have a dimension, gender (M, F) and variable gender_count (=Count(<ID>) In (<Gender>))

So the table comes out like
----------------------
| Gender | Count |
----------------------
| F | 10 |
----------------------
| M | 5 |
----------------------

As you all know bosses want the report to be twisted around them.. now he wants something like

|----------|
| Date |
|-----|----|
| # | % |
|----------|----|-----------
| | F | 10 | x |
| | | | |
| GENDER -----|----------|
| | M | 5 | |
| | | | |
|----------|----|----------|

Can this be done??

 

[blom0344]

Hi Lim,

Your example looks a bit like a crosstab with date in column, gender in row and count in the body. Can you give an example of the dataset as such (with the date-field , that is)? T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com