Is there a way of putting the date column into a matrix that is not a hierarchy,
I can do this using the date column from the fact table, but would prefer to use calendar table as I've gone to the trouble of making it,
essentially the left , which uses the calendar table to look a bit more like the right which uses the date column from fact table. I'd just like the date,
01/01/2020 or something.
Richard.
I can do this using the date column from the fact table, but would prefer to use calendar table as I've gone to the trouble of making it,
essentially the left , which uses the calendar table to look a bit more like the right which uses the date column from fact table. I'd just like the date,
01/01/2020 or something.
Richard.