Table Matrix columns and grouping

[Anonymous]

Hi experts,

I have an issues that I do not have ideas how to do it.

I have 2 tables

product

Product no. QtyOnHand

adn sale

customer Product no. date Qty

I try to make a table matrix to show columns

QtyOnHand only once and then split Qty from table Sale by Month.

Is Possible to show only once a column ?

Thank you

[v-jiascu-msft]

Hi @Anonymous,

Can you share a sample please? What do you mean "show columns QtyOnHand only once"?

Best Regards,

Dale

[Anonymous · Accepted solution]

- Solved by ading a custom column for grouping