Hi,
You can do this in two ways (Calcualted Dimension or Set Expression), the popular one is using Set Expression. Syntax will be as under:-
SUM({$<FY={">=$(=YearName(Max(Date), -1, 4))<=$(=YearName(Max(Date), 0, 4))"}>} Sales).
FYI YearName function is to get financial year which has 3 parameters YearName(<Date>,<YearOffSet>,<MonthOffSet>).
<Date>: Transaction Date
<YearOffSet>: Year off set value i.e. Current year=0, previous year=-1, next year=1 etc.
<MonthOffSet>: Year start from month
Pls revert back for any futher query in this regard.
