Sales Last Year to date Vs Sales Current Year to date

[rammuthiah]

I have requirement like

Comparison between Current year upto Day Vs Last Year upto Day

Current Year = 2017,Current Month = 11,Current Date = 03, So Day will be 3

Want to show comparison like

Prev Year = 2016,Prev Month = 11,Prev Date = 03, Upto Day 3

Any Idea....?

[OmarBenSalem]

please refer to this :

YTD, MTD issue

[zebhashmi]

year()-1