CrossTab query

  • Thread starter Thread starter Krish
  • Start date Start date
K

Krish

I have created a crosstab query using multiple linked tables. I am trying
to get the quantity sum value of various products sold for a given period
broken by market segment.The market segment is the column heading. The
problem I am facing is that the same products list repeatedly for different
dates, broken by market segment. If I switch the date to be column heading,
I am unable to see in a row the market segment. Is there a way to do
multiple column headings? Any suggestion is welcome.

Thanks.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Because the same product is being sold over different dates, you may
wish to use a part of the date (WeekDay, Month, Year) instead of the
individual day date. That will group the dates into smaller groupings.
E.g.:

TRANSFORM Sum(ProdValue) As TheValue
SELECT Product, Format(SalesDate,"MMM") As [Month]
FROM ...
WHERE ...
GROUP BY Product, Format(SalesDate,"MMM")
PIVOT ...

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQVMX9IechKqOuFEgEQLuAACeNomqHkgzlzvgbqEQa9qvCCqZ5aAAn3nj
3+Fsa832b/lKL2iWz0/f4XAD
=0s9W
-----END PGP SIGNATURE-----
 
Back
Top