ignore column in matrix visual

[YBZ]

Hi all,

I have a basic Matrix in which I would like to add a Total column which shows the average cost per row..

I created a measure that calculates the total average. When I add it to the matrix, I have the measure as well in my monthly columns, while I would like to see only thte total average monthly cost.

Anybody knows how I remove the average monthly cost out of the columns? 

Much appreciated as always,

Regards

[YBZ]

Thanks that works. Small problem now exists that my remaining columns are pretty wide as I cannot resize them anymore. Anything I can do about that?

[lbendlin]

Uncheck responsive layout for your visual, or make the entire visual narrower.

[lbendlin · Accepted solution]

Disable auto column resize. Disable column header word wrap. Disable value word wrap.  Then make the offending columns as narrow as you can so they won't show any more.