Forum Discussion
Problem using DateTable columns to create Matrix row hierarchy
I am trying to create a Matrix that uses the DateTable fields to create a row hierarchy but the most granular row is the "StartDate" and that is not the date field being used as the relationship betw...
With that relationship there, you will need to create that inactive relationship, and a measure using that inactive relationship.
From what Ive read you cant use a measure as a row in a matrix, it has to be a column. which is my issue because I cant add new columns to the dataset I am accessing.