Can anyone help me how to combine multiple rows and sum its value when they have the same words?
Example:
User ID | Category ID | Category | Value |
0001 | C001 | Agent | 1 |
0002 | C002 | Client | 2 |
0001 | C003 | Agent | 4 |
Result:
User ID | Category ID | Category | Value |
0001 | C001 | Agent | 5 |
0002 | C002 | Client | 2 |
First, you need to read this:
Data: The Essentials - AppSheet Help
And this:
References between tables - AppSheet Help
Thank @Joseph_Seddik I appreciate it.
Can anyone give me and example?
Sure. There is more than one way, the most suitable of which depends on your exact case. So you might want to describe your need in a bit more detail.
A general, might not be so efficient answer, is to use something like this:
SUM( SELECT(table[Value], AND(
[User ID] = [_ThisRow].[User ID],
[Category ID] = [_ThisRow].[Category ID]
)))
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |