Forum Discussion
Issue with displaying multiple column values in a Matrix
You could try merging the two columns into one so that the matrix isn't handling a nested structure.
CombinedColumn = [SBUOverhead] & " | " & [ProjPropOH]This can be a calculated column, so doesn't affect anything else.
Sweet - just check if you would need either of the individual columns or if the merged one alone would be sufficient so you don't cause yourself pain later on.
If you don't need anything else could you mark my response as an acceptable solution so other people don't spend time responding?
You could try merging the two columns into one so that the matrix isn't handling a nested structure.
CombinedColumn =
[SBUOverhead] & " | " & [ProjPropOH]
This can be a calculated column, so doesn't affect anything else.
Thanks. This gives me an idea to combine them prior to importing so I can make a set of unique combinations.
Sweet - just check if you would need either of the individual columns or if the merged one alone would be sufficient so you don't cause yourself pain later on.
If you don't need anything else could you mark my response as an acceptable solution so other people don't spend time responding?
Will do. One to the next part of this.
Thanks again.