Forum Discussion
matrix table help
Hi there ;
i have a matrix table , in this table i add to value section "order quantity " , but it repeats based on "late " , early" and " on time " .
for "Delivery Qty " everything is ok , it should be repeat based on "late , early and on time ", but for "order quantity " i just want to see only in one column at the right " , is it possible to do in matrix table or i need another visual
could you pls help thanks in advance
I think you need to re-model your data.
Like, create two different tables
Table order quantity = FILTER(Table, Table[value section] = "order quantity")and
Table Delivery Qty = FILTER(Table, Table[value section] = "Delivery Qty")the add 'Table order quantity'[value section] as row, right to [Status] field
3 Replies
You will need another visual. All the measures will show for each category. You could also try the "Show on Rows" feature in the Values format area to see if that gives you a better option.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
thank for info mahoneypat but do you know any other visual that i can show , i tried show on rows but it is not for me
I think you need to re-model your data.
Like, create two different tables
Table order quantity = FILTER(Table, Table[value section] = "order quantity")and
Table Delivery Qty = FILTER(Table, Table[value section] = "Delivery Qty")the add 'Table order quantity'[value section] as row, right to [Status] field
