Summarize Records

Here’s what I’m trying to do:

In Table-1 I have records with a “Created At” field and “Status” field. I’d like to create a new Table where I could see total numbers of records from Table-1 where “Created At” is let’s say May and “Status Field” equals to Done.

I’ve tried linking records from Table-1 to Table-2 and use Rollup filed but it only counts number of linked records, to look like this:

Month - May

Total Sales - 12

Amount - 120$

Any ideas?

Hi @avto_kolashvili,

You can do 2 things that usually helps:

  1. Create a View where you Group by Month and Status, collapse all the Groups and set the Summary value to count.

  2. Create a Pivot Table block

The alternative would be to link the records as you need. You can automate this part with Zapier.

BR,
Mo

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.