Forum Discussion
Solved
Matrix Visual Continuous Table, not summed Months
Hi All, I have this Matrix Visual where the rows are broken up into States, and the columns are date hierarchy. When it is Drilled to the upper level of columns it is perfectly fine. However, wh...
Figured out myself. Instead of using the Date Hierarchy from the Time Dimension table.
Setup another "YearMonthShort", FORMAT ( [Date], "mmm/YYYY" ), and use this for the columns in the Matrix.
Figured out myself. Instead of using the Date Hierarchy from the Time Dimension table.
Setup another "YearMonthShort", FORMAT ( [Date], "mmm/YYYY" ), and use this for the columns in the Matrix.