Good day,
I would like to know how text-type data(weather column) are shown in the red box on the pivot table. Are there alternative ways to set up?
Referring to the images below, I’ve already done that before. And that data was combined with calculated values and concat functions at the same time.
[Text column on the pivot table]
[Using concat function]
I hope I can set up the text column into values on the table.
Best regards,
Boram.
Hello @iamboram, I believe this is a limitation in the pivot table visual. Any field that you add into the values field well will return an aggregation on the field. For string values that will be either count or count distinct. Your best bet will be to switch your visual from a pivot table to a table visual. It won’t function exactly the same way, but you should be able to format the visual closer to your expected output.
I will mark this work-around as the solution, but let me know if you have any remaining questions. Thank you!
