Show only Month in Crosstab

[qcman]

I am creating a crosstab that has 4 years of data (i.e 2009 to 2012).
I only want to show the results for January of each year.
A B C
2009 (Jan) (Jan) (Jan)
2010 (Jan) (Jan) (Jan)
2011 (Jan) (Jan) (Jan)
2012 (Jan) (Jan) (Jan)

 

[lbass]

Create a formula like this and use it for your summary field:

if month({table.date})=1 then
{table.value}

Add your row and column fields as usual.

-LB