Forum Discussion

TomasPac's avatar
TomasPac
Icon for Helper I rankHelper I
5 years ago
Solved

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