Previous YTD Financial Year

Thu, 04 Apr 2013 17:25:38 GMT

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

Re: Previous YTD Financial Year

kaushiknsolanki — Fri, 05 Apr 2013 07:20:53 GMT

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