Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

hiding columns in Matrix

Hi there,   Is it possible to hide columns and keep the total in a matrix. You can do something similar in SSRS by just adding a total at the end of the report.   In the image below, can I hide "...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Frank,

     

    I was able to solve the problem by turning off word wrap in the matrix setting and dragging the field I wanted to hide.

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you Frank, isnt completely what am looking for but thats very close to it. Thanks once again 

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.


Regards,
Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Frank,

     

    I was able to solve the problem by turning off word wrap in the matrix setting and dragging the field I wanted to hide.

     

    • ABC11's avatar
      ABC11
      Resolver I
      4 years ago

      Hi,

      I have similar situation-want to hard hightlighted in yellow color column. Want to see total. I try to follow your solution but lost. 

       

      under which categary I should go for "turning off word wrap " and dragging field

      Please

      Thanks

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        hi 

        iam also facing the same issue can you please help me .i need to hide the order cases i want ordercases in total field.below i have marked i need to hide .

         

         

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      If we squeeze columns, that will hide that column from report users but users who are exporting it to excel will still sble to view the hidden fields. Is there a way to hide from exported file as well.

    • StuartSmith's avatar
      StuartSmith
      Power Participant
      5 years ago

      Nice little workaround with the hiding of the column. 👍  Helped me out.