Matrix visual with totals

[DeBIe]

Hi all,

I think there is a simple solution for my question, but I can't get the visual correct.

What I would like to achieve is a matrix with the totals of several columns per month. When I select a matrix, I do not get the below desired result. Can anybody help me? I Already have the measures like sum of sales/purchases/customers. I also have the date hierarchy for the months. 

	January	February	March
Total Sales	100	200	300
Total Purchases	1000	2000	3000
Total Customers	25	30	35

Thank you very much!

[V-pazhen-msft]

@DeBIe 

Just share a image of the sample. It is hard to say without seeing your table.

Paul Zheng _ Community Support Team

[DeBIe]

For some reason I could not insert a table in this post because of a HTML error.

[DeBIe]

Thank you for your reply

-What I have now is the sales per customer per month in a matrix visual

-What I also have is the total sales per hotel per month

What I would like to achieve is a matrix with the totals of sales / purchases / total (distinct)hotels / total (distinct)customers etc per month.

Thank you for your time

[jaideepnema]

Hi @DeBIe ,

Not very clear ....can you help me understand what is the expected output in your scenario ?