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 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
    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.



    **Was this post helpful? Click the heart icon**

    **Did this solve your problem? Accept it as a solution!**