I am attempting to calculate a running total of all the transactions that match the criteria of the tenant and property column.
Here is table 1 - the transactions.
I am looking to calculate in the Contract rental amount collected column ,in table 2, the running total of any transaction that has matching REF columns Tenant & Property.
Table 2 - total
I tried this formula to do it based on tenants REF alone, but, it did not calculate anything.
If anyone can help me I would be greatly appreciative
You can try
SUM(
SELECT(
table 1[Rentatl Collection Amount],
AND(
[Property] = [_THISROW].[PROPERTY],
[Tenant] = [_THISROW].[TENANT]
)
)
)
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |