Hi all,
I've been struggling to find a solution to the following problem - I think an image might best help explain:
Screenshot 2019-09-09 at 11.23.45.png
I'm looking to create a summary table (the orange one) dependent on how many times a category appears in the blue table. So for example, A appears 3 times in job 1 at a value of £1. It also appears twice in job 2, but at a value of £2.50, etc etc. How can I create the table on the right to correctly have a total value based on how many times it appears in the main data table, and multiply by its respective line value? I hope this makes sense.
Bookmarks