Previous YTD Financial Year

[#1]

Hi all,

Need for all your help,

How to write expression with previous YTD in financial year (start from July end June)?

So, if I click Month : Jan 2013, so it will sum from July 2011 until Jan 2012.

I had success write YTD for current year with this expression :

sum({<Month,FinancialMonth={"<=$(=only(FinancialMonth))"}>} Amount)  

Thanks before.

Regards,

Heri

[kaushiknsolanki · Accepted solution]

Hi,

     You can try this expression.

     Sum({<Date = {">=$(=Yearstart(Max(Date),-1,6))<=$(=addmonths(Max(Date),-12))"},Month=,Year=>}Sales)

     have a look at the attached example.

Regards,

Kaushik Solanki