View or Pivot Table

[I365_Tech]

My table is a transaction log including fields for dates, campaign, onetime/subscription.
How would I create a view or pivot table that displays the totals between dates, within a specific campaign or campaigns, for both one-time and subscription? Perhaps a dashboard with several tables?

[Mohamed_Swella1]

Hi @I365_Tech,

Welcome to Airtable Community! :grinning_face_with_big_eyes:

You can do that in several ways. You can make a new view where you use the Group option to group the records by Campaign and Subscription, filter for specific dates.

You can also use the Chart Block or the Pivot Table Block

BR,
Mo

[I365_Tech]

Thanks. How would I set up the view and group with the dates?

[Mohamed_Swella1]

Hi @I365_Tech,

First, you can add a Grid View from the top left side.

Check this article on the Group By options

Airtable - Support

Guide to grouped records

Airtable's grouped records feature allows you to show your records grouped together based on one (or more) fields of your choosing.  You can also use grouped records to generate reports—see this s...

BR,
Mo