Crosstab with Calculated Columns

[former_member292966]

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

[Former Member · Accepted solution]

Insert the field in the field to summarize and select the summary as % and go to crosstab expert>customize style>select horizontal under summarized fields that shows as a column in the crosstab.

Regards,

Raghavendra

[former_member292966 · Accepted solution]

Thanks Raghavendra.

That did it.

Brian

[Former Member]

(Never mind... I didn't see the answer post before I started typing...)

Edited by: Carl Sopchak on Jan 29, 2009 1:20 PM