Get total of figures with specific currency

Hello Team Wappler,

I am building this test admin backend just to get my hands dirty with Wappler and I need some help.

1. I have a database with the following tables: users, members, tithe, offertory.
2. the tithe table has an amount and a currency column.
3. on my dashboard, I’ll like to display totals of figures in different currencies from my database.
   Example: Total USD contribution is: Sum of all amounts with USD as its currency

Once I know how to do this, I can safely repeat for the other two currencies I have. A million thanks in advance

image.png894×564 54 KB