Is possible to use text values in a pivote table?

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?

Answers

  • amehdad
    amehdad 🟒
    edited November 11

    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
    GrantSmith Indiana πŸ”΄

    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.