I have started a blank canvas instead of using a template to show various data. Is there a way to use a pivot table within a blank canvas?
I want to show points given by each team as the column and each row would be the team then across the top would be each month and then within each would be the number of points given.
I would then want to replicate this with the amount of submissions example is below using the template
No, you can only add pivot tables to dashboard interfaces.
You can also add the pivot table extension to the data layer.
If you’d like to watch a deep dive training session into everything related to pivot tables in Airtable, check out my Airtable podcast appearance at this link: Pivot tables in Airtable
Hope this helps!
If you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
As mentioned by Scott, you cannot do that. However, you can probably show the same information (on a different format) with a bar chart which shows multiple bars, one per “From meta:…” single select option, for each FY record
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.