Need help creating an Expression

[kevin_tran]

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

[Aleksi · Accepted 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”)))

[kevin_tran]

Work perfectly…thank you so much.

[Aleksi]

You’re welcome