Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I m working one query but not able to achieve it.
What is want in final result is i have to create calender for this using min data and max data using this data (I have created it) and for some months we do not have any data for it.
in that case i have show previous month data.
For example:
Case 1 :I have data for Jan 2016 and Next i dont have data for Feb 2016 so if click on Feb 2016 i wan to Pick data for Jan 2016.
Case 2: If i have data Jan 2016 and Nxt if doesn't have data Fab 2016 , Mar 2017 and i have data Apr 2016. i this case i don't have data for two month i.e. Feb and Mar so If i click on Feb 2016 It should show me Jan 2016 and Also if click on Mar 2016 It should show me Jan 2016 bcoz in actual data Only avalilable for Jan 2016.
I hop you understood.
please help me on this.
Anyone have idea to achieve this?
Please help someone on this
Hi,
You can use AsOfPeriod concept.
See attached file.
Hope this helps.