Forum Discussion

radify's avatar
radify
New Member
8 years ago
Solved

How can i hide Column ?

For the data shown below,  it is sorted according to total amount.  How can I hide the column Total but still arrange the quantity base on total amount ?

 

 

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi radify,

     

    This can be done by adjusting the width to 0 like showed in the 3 pictures below:

    1

     

    2

    3

     

    This way the matrix still includes the column in its calculation but it is not visible on visual level.

     

    Regards,

    L.Meijdam

     

     

     

8 Replies

    • radify's avatar
      radify
      New Member
      8 years ago

      Am really new with this.  Thanks a lot.

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi radify,

     

    This can be done by adjusting the width to 0 like showed in the 3 pictures below:

    1

     

    2

    3

     

    This way the matrix still includes the column in its calculation but it is not visible on visual level.

     

    Regards,

    L.Meijdam

     

     

     

    • yamenmarquez's avatar
      yamenmarquez
      Frequent Visitor
      8 years ago

      Hi LMeijdam 

       

      When I try to shrink the width of the column the height of the rows increases. How can I shrink in width without increasing the height of the rows?

      Thanks in advance

      • BigRedDBA's avatar
        BigRedDBA
        New Member
        7 years ago

        If your row height increases as you shrink the width you may have word wrap switched on in either your header or values.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      This does not work for me. If I try to resize the column manuall then the contents wrap up and the row size increases dramatically.