Forum Discussion
Date Hierarchy Showing Year - Measure & Variance Measure Problem
Hi guys. Long time listener, first time caller. My problem is that I can't get the date hierarchy with just the year showing to sort in descending order, and when I try to switch the header to be...
I'm curious about why adding a key to sort it by didn't work. That's what I'd usually recommend for this problem. Something simple like (0-YEAR([date])) would get you the order you want. How/why did it fail to meet your needs?