Help showing a table or list of total values by category

[1805]

Hi everyone
Ive been using Adalo to build an app for the past few months now. Ive managed to work out everything needed as ive gone along but im stuck in one area and wondered if anyone could help.

I have a central project that you can add costs to. These costs are related to another database and all listed. Name, purchase cost and category.

Im trying to have a project financials page where you can see the total costs assigned to that project. On this page I want it to display each category and the total cost. (Along with other financial items)

There are multiple items in the database with different categories.

I want to display something like the below:

Category A - £Total Cost
Category B - £Total Cost etc…

I have tried using a table and tried using a list. Ive got the custom formulas working and im good in that area (I think) but when the data is shown in both the list or table rather than getting the above example I get Category A x the number of entries in the database with the correct total cost shown for all entries (As in the sum of all items in that category) for example:

Category A - £1000
Category A - £1000
Category A - £1000
Category B - £750

How do i get it to show the category name once with a total? Any help would be hugely appreciated.

[JareRamirez]

Hi there!

If formulas are working well this is a nice step done.
Actually i am guessing that you use a list, so, simple list? i recommend to use Custom List for it.

We can solve it whit two steps:

1 - Set a formula which make a final sum of every Cat.A, Cat.B, etc. Per each category in separate text boxes: Cat A, B, C and so on.

2 - Per each text field set Visibility option and hide the text box (must be done in each text box) if Cat. X amount is empty/zero (whatever you need).

Thats my solution and could not be the best, but i am sure it will works.

Regards!
Jare Ramirez