Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Total % on crosstabs

Status
Not open for further replies.

Sidney786

Programmer
Aug 7, 2000
64
GB
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top