Summarize Portal Results

[crazybake]

I currently have a portal that lists all courses taught by an instructor (Year, Quarter, Hours, Percentage, Costs)
I also have a portal within the same layout that includes summary fields (total hours taught and Average).

I need another portal (or...?) within the same layout that has three fields (Year, Quarter, Hours, Total percentage for each quarter) and possibly a running total. I want to quickly see a summary of each quarter instead of having to refer to the complete list of courses and do the math. Seems easy - just not figuring it out.

 

Edited October 7, 2016 by crazybake
forgot one field

[comment]

12 minutes ago, crazybake said:

Seems easy

It's not exactly trivial - see if this helps: http://fmforums.com/topic/71906-getting-more-out-of-filtered-portals-3unique-values/#comment-340017

 

13 minutes ago, crazybake said:

I also have a portal within the same layout that includes summary fields (total hours taught and Average).

Why do you need a portal for this?

 

[crazybake]

Maybe I do not need a 

8 minutes ago, comment said:

Why do you need a portal for this?

 

This particular layout has a dropdown menu for all instructors and I am filtering the portal based on the instructor chosen. I was hoping to get the data I mentioned within the same layout