I want to create a page with my basic home economy.
How can I make it so that I output the total of every concept into a single cell with a function rather then in the whole row?
So, the example below; I want to sum;
Concept 1 = Amount Total (first cell)
Concept 2 = Amount Total (second cell)
Concept 3 = Amount Total (third cell)
Coda lookups are your friend !
You must fill your Dummy Ouput table with effective concept, and call them as lookups in your Dummy 2 table. Then you will be able to select your concept throught a select list using lookups.