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!

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

Cross Tab HELP! Asap!

Status
Not open for further replies.
TerriO

TerriO

Technical User
Jan 9, 2002
84
US
I want to display a percentage of the grand total in the TOTAL column but not for the individual column headings


column Heading APR MAY JUNE Total %

row "Ad Name" 10 10 15 35 35%

Total columns 80 10 10 100 100%

I cant do this without showing a percentage for each Month Column (for APR , MAY, JUNE) is there any way to get around this using a cross tab opposed to doing a manual cross tab?

Terri
 
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
Cross Tab Sorting Columns
Replies
1
Views
442
hilfy
hilfy
bbranco
  • Locked
  • Question
Query Help - Group By 2 tables
Replies
0
Views
432
bbranco
bbranco
smmt2207
  • Locked
  • Question
Text field formula help
Replies
1
Views
515
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
518
SoftwareRT
SoftwareRT
grecon
  • Locked
  • Question
Cross Tab date Selection?
Replies
1
Views
334
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top