Is it possible to have a crosstab with calculated columns? I need to generate a report that looks like:
of Accounts % of Accounts
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.