I’m creating a pivot table, in which I need to indicate in descending order, the largest values. However, in this case I’m counting the number of strings in a column of my dataset.
Can you please clarify if you are trying to sort your pivot table on this column of strings in DESC order based on the length of the string?
If so, you can create a calculated field that leverages the strlen() function.
It would look like: strlen(column_name)
Please let me know if this solution resolves your issue. If it does, please help the community by marking this post as a “Solution.” Thanks!