Calculation in crosstab involving dates

[ajith]

Hey folks

   I have some trouble with the following requirement. I need to create a crosstab report that would list the total number of claims processed from an 'initial date' to 'one-year-prior to the initial date'.

I calculate the total number of claims using Count( ) function.
I have the initial date in my data source (Its a relational data source)
I find the 'One-year-prior to initial date' using _add_date(initial date, -1) function.

The problem I am facing right now is that I am not sure how to combine these in the expression editor to calculate the crosstab column. I tried whatever method I knew and I keep on getting error messages. Any suggestions would be highly appreciated.

thanks!