I have a table with costs with these fields:
Date / Descr / Category (4 options) / Price / VAT / Quarter (calculated based on date)
How would I get this report table as output in Airtable for Q1:
Category / Price (sum per category) / VAT (sum per cat...
Yes, so too much for manually adding date columns.
However you could use my method to create a new view Entry where user types Total and in the next field the daily sales are calculated for the user as a ‘suggestion’ to type in in the field after tha...
Ah, aggregates. Depends on how many days you want to look back. Only 3 I would do it like this:
In Reports an extra calculated field Days ago (0,1 or 2) then a column today: if daysago=0 then Sales else “”. For yesterday and day before same formulas ...
Make table Reports with fields: ID, date, city, #, sum
And table Cities (name of the cities).
In Reports: make a record for each day for each city, so 9 records in your example. Link field Cities to the table Cities. You should be able to do all the ...
Shorter description:
Add extra Sum table and under Name type Sum of Costs, so just one record in this table.
Now go to Cost table and add a field with link to the Sum table.
Link the first record to the one field.
Copy this to the other records.
In S...
