Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a set analysis where I am trying to include the latest date from the date dimension. How would I include to select the max date?
Sum({$<Division = {WAS}=>} DeclinedCount)
Date={'$(=Max(Date))'}
Sum({$<Division = {WAS}, Date={'$(=Max(Date))'}>} DeclinedCount)
Date={'$(=Max(Date))'}
Sum({$<Division = {WAS}, Date={'$(=Max(Date))'}>} DeclinedCount)
This logic works until you select a month, for example May 2013. I'm guessing QVW does not know which day in May to match to and therefore does not display anything. How can we tweak this so it will work whether the user has selected a month, quarter, or day?
Thanks!