Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
i have a problem. i want to compare YOY revenue in my dashboard. but when i do the comparison, for example, if i have data till may of 2015. it is comparing with the entire revenue for 2014. i dont want like that. i want to compare till 2014 may only when i comparing 2015 may. i am sending you the table and code which i have used. please help me.
Date | Revenue |
---|---|
12-jan-2014 | 123234 |
3-feb-2014 | 234234 |
: | : |
: | : |
1-jan-2015 | 1212313 |
1-feb-2015 | 334341 |
1-mar-2015 | 423424 |
1-april-2015 | 3434321 |
1-may-2015 | 23432423 |
"=sum({<Year = {$(=max(Year))}>}(Revenue))/sum({<Year = {$(=max(Year)-1)}>}(Revenue))"
I am using Universal Calender for the tables.
this should help
Hi Amith, There is more then one possible way, describing one over here. Logic is.(This will work on your selection of year).
1. For current Year you just need = sum(revenue)
2. Previous month revenue according to current year Dates = sum({<Year={'$(=max(Year)-1)'},Date={">=$(vPYMinDate)<=$(vPYMaxDate)"}>}Revenue).
3. You can find these variables in application.
4. here attached solution qvw on your data .PFA
Regards
Ankit