Cross-Tab complex problems..Pls help URGENT

[bandi200]

Hi,
Can some body pls help us..

I trying to print summary of totals first By each day, then by each week ..Ima trying to use Cross-Tab..
all the data for each day comes fine but the totals coming out for each week summary is not what I want..

|Mon Tue|Wed|Thurs|fri|sat|wklytot
A #pkgs |sum1 | | | | |totsumx1
totwt |sum2 | | | | |totsumx2
Lbs/Pkgs|sum2/sum1 | | | | |totsumx2/totsumx1

b .
.
.
------------------------------------------------------------Tots pkgs |sumy of Pack
wt |sumy of wt
Lbs/Pkgs|sumy of wt/sumy of Pack

Iam trying to use one cross-tab..but could not get the summaries what i want..can some body suggest a solution for this
i really appreaciate it.

Thanks in advance
Reddy