In an Interface, how to show just the Total column on a Pivot Table

Question

I am having an issue where I have a table that calculates a sum Total. I figured I could easily just show a user’s name + total on the interface but it seems very hard for some reason.

Right now, I get the sum with a user’s name, but it then adds all of these columns for each unique sum there is within the data set.

Example Image:

And here is what the data looks like

So I am just trying to make a table on the interface (as we will share that view) that simply shows Name + Total.

I have a bar chart showing this, which kind of works, but just having 2 columns with plain text would be nice too in the interface.

Thank you!

ScottWorld · Accepted Answer

If you only want to see name & total, the pivot table is not the right element for this.

Instead, you can add a list onto your dashboard interface, and only show those 2 columns: name and total.

However, since you already have a bar chart, you can also just double-click on the bar chart to open the list of records that comprise the bar chart, and you can choose to display just those 2 columns: name and total.

Alternatively, on a dashboard interface, number elements are designed to show you totals, so you could place multiple number elements in a row on your screen — each one with a different person’s totals.

Additionally, you can choose a pie chart (or bar chart, as mentioned above) if you want to see a visualization of the totals, and then you can double-click on the chart to zoom into the list of names and totals.

You could even create an entire “list interface page” or an entire “grid interface page” to display name and total, but those would take up the entirety of your entire page.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Mike_AutomaticN · Answer

Hey ​@aanders50!Were you able to get this solved?I would follow Scott’s advise on this one, and use a different element to this effect.Please let me know if you’d like to go through this together on a very brief call. Happy to help.Mike, Consultant @ Automatic Nation

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded