matrix table help

[erhan_79]

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 

[mahoneypat]

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

[erhan_79]

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

[az38 · Accepted solution]

@erhan_79 

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