Skip to main content

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?

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

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


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

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


Hi @I365_Tech,


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


Check this article on the Group By options




BR,

Mo

Reply


Terms & Conditions