Interface designer rollup category values

Topic Labels: Interface Designer
299 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi Everyone,

I can't seem to figure out how to make a summary of all the expense records within a category. I have a table with  expense names with their respective number values and a single select to categorize the expense.

However when in the interface designer I can't seem to "rollup" "sum(value)" per category to report the high level rather than every list item. 


1 Reply 1

Try adding a "Number" element, making it only show specific records and filter to the category, and make it a field summary that sums on your amount field:

Screenshot 2023-04-13 at 1.36.17 PM.png

Screenshot 2023-04-13 at 1.36.37 PM.png

Link to base