CROSSTAB Date frame assistance

[LOUM]

Good Day Everyone,

I am trying to write a data item in my query that basically takes the date of the transaction and then sums my totals.

Between date 1 and date 2 sum (qty)  "This equals 3 months usage."
Betweeen date 3 and 4   sum (qty)       "This equals 3 to 6 month usage"
Betweeen date 5 and 6   sum (qty)        "6 to 9 month usage"

Any ideas?

[pricter]

Try the following
Create the following data items one for each period you want

if (date between 1 and 2) then (your measure) else 0 "This equals 3 months usage."
if (date between 3 and 4) then (your measure) else 0 "This equals 3 to 6 month usage"
if (date between 5 and 6) then (your measure) else 0       "6 to 9 month usage" "6 to 9 month usage"

PS: Remember that there is the month function that returns the month of a date