I would like to know if its possible to create a HTML view which shows a summary of two forms that are related.

My situation is as thus: I have two forms Clients and Commissions. In the Clients form I have an agent and client. In the Commissions form I input the commission for each client. [This is the related link].

I would like to know if its possible to have a HTML view which allows me to show the total received by each agent, and I can also choose the month. The HTML view should show all the clients that the agent received a commission for a particular month. 

Additionally, a client can purchase a range of products and I would like to have sub totals for each group of products in the HTML view is this possible?

Kind regards