How to show last Yr and last month...in set analysis

[mohammadkhatimi]

Hi Everyone,

How to show last Fiscal Month of Last Fiscal year.

For e.g- Fiscal year-2015-2016 Apr Month is selected....the data should show March of Fiscal Year 2014-15.

Any help would highly appreciate.......................

Regards,

Mohammad

[buzzy996]

try this,

=num(sum({$<Year = {$(=only(Year) - 1)}, Month = {"<=$(=max(Month-1))"}>} LineSalesAmount), '$#,##0;($#,##0)')

[sunilkumarqv]

Hi Mohammand

Last Fisc Year  And last Month

Sum({<Year=, Month=, Quarter=, Week=, DateField=,Year={$(=Max(Year)-1)}, DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} Sales)

[mohammadkhatimi]

Not working...

[mohammadkhatimi]

In dat app i didnt get solution..

[sunilkumarqv]

Can u share app ?

[mohammadkhatimi]

My year field is in Fiscal Year format....

Please read my post...I have given the e.g what exactly i want.

Regards,

Mohammad

[buzzy996]

hi,r u tried this?

[mohammadkhatimi]

Yess...

Couldnt solve my issue...

Have you understand my requirement???

[buzzy996]

yes dear,hopes tht will works..

the expression I shared will provides

if u select 2015 mar the above will provide 2014 feb ytd results

if u select 2015 may the above will provide 2014 apr ytd results