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.
This is looking better but there are still a bunch of blank values that are calculating infinity. I am not sure where the blanks are coming from, there are no blanks in the data