Date Grouping

[#1]

I have a date field with forward looking dates (forthcoming orders). What I wouldl like to have happen, is if the date is greater than my fiscal year end month, that all of the dollars associated with the greater dates can be grouped and summed as a "Beyond" date. The rub is I would like it to be part of the date selection.

So my fiscal year goess from April 2011 - Mar 2012. I need to look at sales by month, but also want to know how many dollars lies outside of my fiscal.

Thanx

[prieper]

so, why don't you construct a formula like

IF(MyDate > EndOfFiscalYear, 'Beyond Fiscal Year', MyDate)     AS DateCalculated

HTH
Peter