Pivot table - change show records details

[Gustavo_VD]

Hi! I’m using the Pivot Table extension to summarize my expenses per category/month. It works a treat:

Better yet, when I click on the values on my table it shows me the records related to that specific value (the expenses related to that category/month).

Almost perfect, but the information shown on the right side is not really helpful. I’d love to be able to see custom information like the Amount and Payee (both are columns on my table) in the summary of each record.

I understand Airtable is choosing the info that gets displayed because they are the values used on the pivot table, but they are repeated and not very helpful. Is there a way to choose what gets shown there?

Thank you!

[Hannah_Wiginton]

There’s not a specific way to change it, but I wonder if you could make a Formula field and CONCATENATE the fields you want to see

Airtable Support

Joining field values

There are a couple of ways to combine the values in multiple fields together within a formula field. This lesson will cover those methods and a few tips to enhance their functionality. This article...

[Gustavo_VD]

Hi @Hannah_Wiginton, yes that’s a great idea and definitely a step in the right direction. But how do I make sure the concatenated field shows up in that side bar?

[Gustavo_VD]

Just bumping this post to see if anyone else has any other idea that could help.