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
-
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).
7 -
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 Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部