How can I count/aggregate like/common fields?


#1

I have a table like this:

I want to create a new table that lists all the different Parts with the total of each time that part occurs and the How Many in each row. This is just to create an order list without repeating the rows.

I figure rollups might be the solution but I can’t figure this one out.


#2

What tables do you have? Could you explain a little deeper your base (or even share a copy)?

I think you have to create a new View in the Parts table, or maybe an auxiliary table in between. I’d need more understanding of your base :thinking:

Bye!


#3

I think I’ve figured this one out. But thanks :slight_smile:


#4

Could you share the solution? I’m curious now! :slight_smile:


#5

Well it’s only a crude solution. I group by the product and then use the
count summary on the field that holds the number of each.

What I really want is a new table that lists every part as a new entry with
the sum next to it.

You can see I am just trying to figure out how many of each part I need to
fulfill the current outstanding orders.