Forum Discussion

Soc3's avatar
Soc3
Helper I
1 year ago
Solved

Matrix Table- Single Column Value and Previous Year Measure

I have names in the rows (hidden for privacy purposes), dates in the columns and percentages in the values (a measure). I want to add a single column that states what the target is.       H...
Need Help
  • kushanNa's avatar
    kushanNa
    1 year ago

    Hi Soc3 

     

    If you need the Target to appear next to the row value only once, you can create a calculated column with the target and use it as a row, then change the matrix table layout style to Tabular.

     

     

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
1 year ago

Hi Soc3,

Please try moving the issue year field from the rows section to the columns section. See the screenshot below for your reference.

I hope this resolves your issue.

 

Thank you.

Soc3's avatar
Soc3
Helper I
1 year ago

Thank you. Because the previous YR and Target % values don't change each month, is there a way to only show those columns once?

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    Hi Soc3,

    We cannot show these columns only once in the matrix.

     

    Thank you.