Skip to Content
0
Jan 29, 2009 at 04:48 PM

Crosstab with Calculated Columns

19 Views

Hi,

Is it possible to have a crosstab with calculated columns? I need to generate a report that looks like:

2007

  1. 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