I have a portal which lists expenses on a project. On this same layout i want to sum each type of expense listed in the portal. For example if i have three 'tax' expenses, i want the tax field to sum all three tax amounts. If i have five water expenses, i want the water field to sum all of the water amounts. Etc, etc.
I'm assuming i need to write an if statement within these fields to get the itemized expense type totals, however i've been unable to write the correct statement.
Is that the correct approach? If not, what would be an easier way to doing this?