Manual Cross-tab

[MadCatmk2]

Hi all

I'm trying to do a cross-tab table to show a count of visits for each month for a given initial year and a given last year. I know i could do this using the cross tab expert apart from one thing. The expert doesn't seem to allow a column that stores the difference between the yearly values.

the table should look something like this:

2002 2003 Diff
Jan 24032 27032 3000
Feb 16000 17000 1000
etc...

The problem i'm having is how to set up a count for the two years for each month. Initially i have grouped on the month field. COuld someone please enlighten me as to how to count the records that only match the year that is being calculated.

Hope this makes sense

Thanks in advance

 

[MadCatmk2]

I've managed to find something on the forum that has helped me solve the problem. Thanks to Howard Hammerman's FAQ i have created a working manual crosstab.

The link to the FAQ is:

http://www.tek-tips.com/faqs.cfm?spid=149&rat1=10&sfid=1219

Thanks.