Hi
I am trying to apply total percentage to a crosstab report.
I have revenue as 1 row
I have Sales targets as 2 row
and periods as columns
At present the total sales target is showing an addition of rev/sales target.
However i would like to show in the total column total revenue / total sales targets
Jan Feb Mar Tot
Revenue 1000 900 500 2400
ST 500 500 700 1700
% Acheived [highlight #EF2929]200[/highlight]$ [highlight #EF2929]180[/highlight]% [highlight #EF2929]71[/highlight]% 451%
I want to see
Jan Feb Mar Tot
Revenue 1000 900 500 [highlight #EF2929]2400[/highlight]
ST 500 500 700 [highlight #EF2929]1700[/highlight]
% Acheived 200$ 180% 71% 141%
Any help would be useful
Thanks
Sid
I am trying to apply total percentage to a crosstab report.
I have revenue as 1 row
I have Sales targets as 2 row
and periods as columns
At present the total sales target is showing an addition of rev/sales target.
However i would like to show in the total column total revenue / total sales targets
Jan Feb Mar Tot
Revenue 1000 900 500 2400
ST 500 500 700 1700
% Acheived [highlight #EF2929]200[/highlight]$ [highlight #EF2929]180[/highlight]% [highlight #EF2929]71[/highlight]% 451%
I want to see
Jan Feb Mar Tot
Revenue 1000 900 500 [highlight #EF2929]2400[/highlight]
ST 500 500 700 [highlight #EF2929]1700[/highlight]
% Acheived 200$ 180% 71% 141%
Any help would be useful
Thanks
Sid