Forum Discussion

MRHUP's avatar
MRHUP
Frequent Visitor
4 years ago
Solved

How to place an extra column in a matrix (based on a string)?

Hi,   For an assignment I am looking for a solution, hopefully it is possible.... In a Matrix, after a regular count of the number of some  occurrences, I want to add an extra column for clarificat...
column
matrix
Matrix table
  • tamerj1's avatar
    tamerj1
    4 years ago

    MRHUP 

    Sure. But from the format settings make sure you don't select "measure on rows" and you have (compared to the given example) the category on rows and the color on columns. Also what are the empty rows that is shown in the last screenshot?

MRHUP's avatar
MRHUP
Frequent Visitor
4 years ago

Ha yes I know, the allignment isn't that hard, also blanked out the total for the A1 - A16 fields (this total doesn't make any sense). But I expected the full A1 to A16 in the matrix (as in the example in the first post). Played around a bit, and the 'trick' for this was; use the same measures / columns as used in the matrix itself... 😉 I used a different column in the measure, this column contains the color codes. The matrix itself then includes the column of the actual colors. And then something doesn't go quite right....

 

Thanks for your help!