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

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 .

     

     

    • AGhyst's avatar
      AGhyst
      Frequent Visitor
      4 years ago

      Someone else will probably have a better solution but this reminds me of one that I had a problem with because I needed 3 year's sales but only current year's budget.   I found the cleanest solution was to write measures for each year and one for the budget then put them into a table.   Had the advantage of giving me measures I could use for other calculations

      So I think you could write a CALCULATE for each of your fill rates and then a total for your cases to build something similar. 🙂

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi,

        how to write the calculate function fillrate is the calculated measure and ordercases is a column periods also columns .

        fillrate=sum of ordered cases/shipped cases 

        i have calculated