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

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 

Hi ​@ScottWorld and ​@Mike_AutomaticN the List view worked! Just didn’t think from the name that it would be what I needed. :) 

Thanks!