Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have several years worth of Sales history and have filters on the page to display various measures by Year. When you load the page, not year is selected so you get a summary for ALL years. I would like to automatically (on load) select the current year data without the user needing to physically select the year.
Does anyone know how to automatically filter data on the initial load of the page?
Hi Kenneth,
You can achive this with formulas in objects.
e.g.:
if(getselectedcount(Date)=0,sum({$<Date={'$(=year(now()))'}>} measure),sum(measure))
You can implement more difficult function to implement what you desire.
G.