cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

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 Capture1.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: s Re: matrix table help

@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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: matrix table help

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

Highlighted
Post Patron
Post Patron

s Re: matrix table help

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

Highlighted
Super User II
Super User II

Re: s Re: matrix table help

@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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Top Solution Authors
Top Kudoed Authors