Forum Discussion
How to filter table by a value as a category
Please help..
I need table values "Object" to be as a category for other values:
I will write some examples:
1. The column "Object" in my table holds site names, which are making supply orders.
2. Each site has it's own orders as a table row.
3. There are many different kind of data for an order, like "supplier", "quantity", "price", "date planned" and so on.
So right now if one "Object" has 5 supply orders, my table has 5 different rows with the same "Object" value.
What I need is "Object" values to be like a category for every other subcategory and value.
What I have now:
Object | order no | quantity | price | date planned
site1 order1 10 20 2021-01-01
site1 order2 20 30 2021-01-01
site1 order3 5 15 2021-01-04
site2 order4 30 20 2021-01-06
site2 order5 50 100 2021-01-10
What I need:
Object | order no | quantity | price | date planned
site1 -------------------------------------------------
order1 10 10 2021-01-01
order2 20 30 2021-01-01
order3 5 15 2021-01-04
site2 -------------------------------------------------
order4 30 20 2021-01-06
order5 50 100 2021-01-10
Hi TomasPac
Please format the matrix visual like below.
Put Object and Order No. columns in Rows fields, put other values in Values fields. Go to Format > Row headers > turn off Stepped layout and +/- icons.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
2 Replies
- amitchandak
Super User
TomasPac , check with stepped layout off and expand all in a matrix
- v-jingzhang
Community Support
Hi TomasPac
Please format the matrix visual like below.
Put Object and Order No. columns in Rows fields, put other values in Values fields. Go to Format > Row headers > turn off Stepped layout and +/- icons.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.