Crosstab with Calculated Columns
Hi,
Is it possible to have a crosstab with calculated columns? I need to generate a report that looks like:
2007
of Accounts % of Accounts
Balance Range
0 - 199 10,469 6.5%
200 - 400 18,822 11.7%
:
:
Grand Total 160,678 100.0%
The balance range is a group I already have.
The columns are grouped by Year which is easy enough.
The # of Accounts I can get from the Summarized Fields.
The question is how to get the % to appear as a column instead of a row.
The only way I can see to get the % into the report is as a summarized field and that will work but it won't match the formatting my client needs.
Thanks,
Brian