Forum Discussion
Date hierarchy please help
I am trying to use a calendar table related to two other tables containing my data. I want to show my data quarterly, but when I choose to mark my calendar table as a date table, I lose my date hiera...
Hi! It looks like you have Date as part of your hierarchy. Try creating your hierarchy with just year-qtr-mth-day.
Ok nevermind I am able to filter out the blank values so I am getting somewhere. The last issue is sorting the dates. I am guessing I can't manually sort them?