Summarize Records

840 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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.