Roll up several Fields (columns)


#1

I am trying to create an analytics table for my reatail business and I created a sheet that includes all the poducts. I have a different table per day that I have sells so in the analytics table I added a column and linked the sells I have per day.

What I want to do is to rollup all colums I have in the analytics so I can see my sales per day. How can I rollup sum different colums to get a total per month???


#2

If you are marking each “Sale” with in your “Sales Per Day” table with a date, It might be better to use Airtable’s built in grouping feature, and then use the Aggregation Bar that Airtable provides on a “per group” basis. Below are a couple posts explaining how you might achieve this simple approach:


But you can also do what you are asking by linking records to a “Day” analytics record in the Analytics table. You’ll do similar to how I’ve done in the post below, but use a “Day” as the record in the “Summaries” or “Analytics” table, instead of a “Month”:


#3

Hi Jeremy,

I dont think I am explaining myself let me show you a screenshot to my table. As ou can see the analytics table I have the perday count of the client that orders that product (their name appears) by basically linkin every sales day I have. I will like to find out the rollup of all sale days that I have and not per day which is what the rollup function is letting me do.

I know could create a rollup per sales day and then sum them all but theres have to be a more practial way to do this. for example in excel I could just go for a sumif formula and add everything but I am not sure if that is possible in airtable.


#4

I’m going to send you a PM about your base. Keep a lookout for it soon.