I have a google sheet with the following sheets:
Transaction
Member
Can someone help me create a VIEW which displays the following information:
MEMBER NAME
Category NAME: Sum of AMOUNT per CATEGORY
I have working on the expression for the last 2 weeks and I can not seem to get it right. Any help would be greatly appreciated.
Kevin
Solved! Go to Solution.
Not sure how you would like to calculate it but you could start from this…
SUM(SELECT(Transaction[Amount],AND([To]=[_THISROW].[Name],[Category]=“Salary”)))
Not sure how you would like to calculate it but you could start from this…
SUM(SELECT(Transaction[Amount],AND([To]=[_THISROW].[Name],[Category]=“Salary”)))
Work perfectly…thank you so much.
You’re welcome
User | Count |
---|---|
38 | |
32 | |
30 | |
17 | |
16 |