Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
i wand to create YTD but according to fiscal year that starts from "April" .suppose i am having three fields(book_id,date,customer,cost) and i want to do sum of cost but according to YTD.
EX- if i select date '02/02/2016' then my sum of cost should be from(01/04/2015) to (02/02/2016)
Thanks!!!!!!!!!!
hi
I have seen that but using that query the year starts from 'jan' but in my case it should start from 'april'.
So can you please send me the query for above given condition
Hi Anil,
i am having fiscal month and fiscal year as one of my field,can you send me exact set analysis statement!!!
Hi,
Does the fiscal month-year field contain the full date information in the underlying data (day,month and year)? What date format are you using? Depending on how you implement it the set analysis for filtering the dates can be different.
You want to show, Fiscal YTD depends on selection. I mean if you select 01st Jan 2016. Here, You want to show From Apr 1st 2015 - Current Selection / What? Can you please elaborate more?
if you select 01/01/2016 means summation should be between 01/04/2015 to 01/01/2016