Forum Discussion

Wouter1234's avatar
Wouter1234
New Member
1 year ago

How to export additional data from a matrix

I have a matrix with column C. Column C is generated by the summation of column A & column B. When I apply my filters and want to export data, I would like to export column A, B and C, but only visually display column C in the matrix.

 

I can not add a "hidden column" by adding column A and B and reducing the size to zero, because the row height will increase.

 

Need Help
Tips and Tricks

2 Replies

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    Hi Wouter1234 ,

    As suggested by lbendlin , to avoid increase of row height, you will need to disable the text wrap in the values section.

     

    1- Select your matrix, and go to format pane, expanda the value section, and disable the text wrap as shown bellow: