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