How to remove columns in matrix and show only total?

[Zinepat]

My purpose is Want to show the actual sales value by date

but after the actual sales total Want to show Target and percentages, etc. at the end of the actual sales total.

Now I use a way to hide the columns I don't need, but it's not pretty because the column border is not straight.Next in the actual sales total, there will be 4-5 more columns. And it's hard to hide the columns of every date.

If you have another way, please suggest.
thank you very much.

[v-yanjiang-msft]

Hi @Zinepat ,

According to your description, I have two suggestions.

1.Hide unwanted columns like you did and set the Column headers Backgroud to white, then the column borders can not be visible.

2.Create two matrix visuals, one of them only filters out actual data, the other one contains actual and target data.

Put the first view on top of the second view, blocking the left part, only showing the total part.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.