Hi - i used search but only found different things asked … and the only similar question was closed and not aswered. … so i´ll try my luck here
It basically is something like an inventory roundup or item count on an invoice. I want to create a rollup field that gives me the counts of duplicates in a group in another table.
Table 1 contains “roles”
I can have multiple lines with the same role. eg:
Field1 - Field2
Day1 - Role1
Day1 - Role1
Day1 - Role1
Day1 - Role2
Day1 - Role2
Day2 - Role1
Day2 - Role2
In table two i want to roll them up to something like:
Day1: 3x Role1, 2x Role2
Day2: 1X Role1, 1x Role2
i found a solution where all options are hard coded … that is not usable as there are over 500 “Roles” already and we need to add more over time.
any way of doing this? probably very easy and im just to blind to see the light …
thanks!