I need to track sales from a specific period that does not follow a normal calendar year. In my documents I will have a date, eg. 4/1/2006 or 3/31/2007
The reporting year needs to be 4/1/xx through 3/31/xx -- this spans two years.
In my view, I'd like to list the year first eg. 2006 and total fields from documents that include a sales date from 4/1/2006 through 3/31/2007 and then the next category in the view will be 2007, and these will total documents from 4/1/2007 through 3/31/2008.
Can this be done??