I am struggling with finding a function in Looker that would enable summing rows that satisfy a specific condition. I have multiple lines with items belonging to 1 client and a table that contains multiple clients. For each specific client, I want to show the total number of items (in order to calculate the relative frequency per item).
In for example Excel, one would simply use a sumif function. This would sum all values from the column items that have a value for Client in their row, which is the same as the value for Client in the row for which the formula was set up. This is illustrated below:
How can you construct this in looker?