Calculating total monthly

[GarryVa]

Hello Gliders, I’d like to display sum of prices depending of month column.

In other words, I’d like to automate total calculation of commissions at the end of each month. Here is a screenshot :

And here a preview of what I would like to get :

How to do it? Do I need to create another table?

Thank you

[Jeff_Hager]

Use the same table or create another table with the month. Then create a relation linking the months together. Then create a Rollup column to sum the amounts from the relation.

[GarryVa]

Ok thank you @Jeff_Hager , it works. But do you have any idea to display only one item each month ?

I tried to use “Limit number of items” option but I’m not sure that it will show one item by month :

[Darren_Murphy]

• Add a RowID column to your table
• Add a Single Value column that selects the first RowID value via the relation column.
• Add an if-then-else column:
  – If RowID is Single Value RowID, then Rollup Amount
• Use the if-then-else column as a filter on your collection - only show rows where it is not empty.

[GarryVa]

Thank you all @Jeff_Hager and @Darren_Murphy , it works perfectly !!

[MattLB]

Great technique - thanks Jeff and Darren