YTD

[lionking15]

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!!!!!!!!!!

[agomes1971]

Hi,

please see this

YTQ, QTD, MTD and WTD

HTH

André Gomes

[lionking15]

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

[Anonymous]

Hi

Have a look:

Set Analysis for Rolling Periods

Set Analysis for certain Point in Time

Hope it helps!!

[Anonymous]

Try this

Fiscal and Standard Calendar generation

Hope it helps!!

[lionking15]

Hi Anil,

i am having fiscal month and fiscal year as one of my field,can you send me exact set analysis statement!!!

[cesaraccardi]

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.

[Anil_Babu_Samineni]

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?

[lionking15]

[lionking15]

if you select 01/01/2016 means summation should be between 01/04/2015 to 01/01/2016