Calculated View per meeting, per role, per member

I have a couple of boards:

  • Committee Roles
  • Committee Meetings
  • Committee Members

Now my problem or challenge is that I require to calculate the Member’s cost for assisting with the meetings that is specified in the committee roles. In example, I require the chair of the meeting to be paid “$20” per meeting attended on that specific role for that specific meeting. Now it is difficult to figure out how to pull a report on the member for the amount of meetings as well as type and the roles the member has been assisting with in those meetings. Can someone assist me with a view or dashboard that can show me how to do this please? I thank you for your time.

Regards
Hendrik