Skip to Content
0
Apr 15, 2014 at 06:01 AM

Crosstab column formatting

140 Views

I'm creating a crosstab report with a Current Year & a Last Year column. I've added 2 calculated columns to show a variance $ and a variance % between current & last year.

I have no problem coming up with the results. My dilemma is to format the 2 added columns as currency and percentage. When I try to change the percentage column's format to percent, all other columns in the crosstab also change to percent.

Can someone out there tell me if there's a way to create 2 different formats for the 2 added columns? I'd really appreciate it. Thank you very much for your help. I've been struggling with this issue for quite sometime.😢