Yes. I did it.
Here is the solution:
CALCULATED FIELD FOR 2012-2013 (name 2012-2013 Period)
IF DATEPART('year',[Date]) != 2014 THEN "2012-2013"
CALCULATED FIELD FOR 2013-2014 (name 2013-2014 Period)
IF DATEPART('year',[Date]) != 2012 THEN "2013-2014"
CREATE A PARAMETER (name Period)
integer, 1 for 2012-2013 and 2 for 2013-2014
CALCULATED FIELD TO VALIDATE PARAMETER (name Valid Period)
IF [Period] = 1 THEN [2012-2013] ELSE [2013-2014] END
INCLUDE THE CALCULATED FIELD [Valid Period] in the filter
Choose to exclude NULL
Thanks for posting your solution, and marking the answer "correct". Glad you got it working--cheers!
Thank you Matthew.
The good part of this is that it can be used for many dates aggregation as you want, specially aggregations that uses the same part of the date more then one time.
For example, if a client has a fiscal year from July to June and also would like to see the data in the ordinary year format (Jan to Dec) it can be done using the logical above.