Is possible to use text values in a pivote table?

ramoshe · November 2021

Hello! I am trying to create a table like this in which the values are a text field.

I am using the pivote table that allows me to create the headers the way I want them but I think this type of chart only allows me to use numerical values.

Is possible to use text values in a pivote table?

amehdad · November 2021

Hi @ramoshe, the Pivot table will only accept 'Measures' in the Values field. You'll likely have to forgo the multiple headers options for your table (by choosing a different Table chart type that will enable text values in the cells) and instead have those header options as filter cards next to the table in your page/dashboard (e.g. LO type = LO1, LO2 etc).

GrantSmith · November 2021

You could attempt to use a magic Etl and the pivot tile to process your data into the pivot format you’re wanting and then use a standard table to display that information.

Is possible to use text values in a pivote table?

Answers

Categories