hi.....i am trying to create a cross table report...but i m not getting any idea about how to do so...
here is my data
i hve a tabe with three columns
date Category unit
1/1/2008 a 2
1/2/2008 a 3
1/3/2008 a 8
i want the cross table to have the output as follows
date a
1/1/2008 2
1/2/2008 3
1/3/2008 8
and also i want to add unit column according to weekly,monthly and yearly data...any help would greatly appreciated.
thank you
here is my data
i hve a tabe with three columns
date Category unit
1/1/2008 a 2
1/2/2008 a 3
1/3/2008 a 8
i want the cross table to have the output as follows
date a
1/1/2008 2
1/2/2008 3
1/3/2008 8
and also i want to add unit column according to weekly,monthly and yearly data...any help would greatly appreciated.
thank you