Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Antonio,
All the values In the last column YTD 20140805 PriorYearDate are 0 for every month of 2015.
Kind regards,
Ambertje
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
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
okay...the above screenshot should show as a result but on the click of what???
Please give full detail..
Good morning Kavita,
If I click on Year 2015 and month aug.
Kind regards,
Ambertje
Check the attached qvw
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
hahaha...dats funny...