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
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 

  • AGhyst's avatar
    AGhyst
    Frequent Visitor
    4 years ago

    I'm not great at DAX but this is what I would try.  Essentially you can use CALCULATE as a filter. You would need a new measure for each of the fill rate columns you want and you can build it using the fillrate you already did.  I'm not sure what the name of the column field is so...

     

    8x1 Fill Rate=CALCULATE(fillrate, [Field]="8x1")

    8x2 Fill Rate=CALCULATE(fillrate, [Field]="8x2")

    8x3 Fill Rate=CALCULATE(fillrate, [Field]="8x3")

    8x4 Fill Rate=CALCULATE(fillrate, [Field]="8x4")

     

    Then you would need to make a measure for your Ordered Cases (not sure if you have any filters on cases but if so you could use calculate to get it right).

    Ordered Cases Total = SUM[ordered cases]

     

    If you want the Total Fill Rate at the end you will need one more measure

    Total Fill Rate=CALCULATE(fillrate)

     

    Then drop all the measures onto a table in the order you want to see them.   Depending on how your calculations work with your data it can take some fine tuning.  Hopefully, that works--like I said I'm no expert lol.