Can't get Prior Year (YTD) to work

[amber2000]

Hello everybody,

I've read a lot about YTD, MTD  and I'm trying to implement this in my report.

I have 2 years of data(from jan 2014 untill now 2015)

In my KPI meter I want to show the sum of a value from today (05/08/2015) untill last year (05/08/2014)

YTD MaxDate is working great 😉

YTD PriorYearDate gives me 0's and shows no value at all.

Am I doing something wrong?

I attach my report so everyone can see what I mean.

Can anybody help me out please???

Kind regards,

Ambertje

[amber2000]

Hi Antonio,

All the values In the last column YTD 20140805 PriorYearDate are 0 for every month of 2015.

Kind regards,

Ambertje

[maximiliano_vel]

Perhaps I did a mistake in the data model, however you should check your date fields, since there are in different formats i found some dates with YYYYMMDD format and others with the format DD/MM/YYYY, this should be corrected...

Regards

[antoniotiman]

Hi,

in last column set analysis is

......Calendar_day <= 20140731

so You can't have 2015 in this column.

You have 2015 in Column YTD Max Year

[kavita25]

okay...the above screenshot should show as a result but on the click of what???

Please give full detail..

[amber2000]

Good morning Kavita,

If I click on Year 2015 and month aug.

Kind regards,

Ambertje

[kavita25 · Accepted solution]

Check the attached qvw

[amber2000]

Kavita,

This is exactly what I was looking for, you are amazing and I thank you from the bottom of my heart.

I can jump for joy

Kind regards,

Ambertje

[kavita25]

hahaha...dats funny...