Can we please have a feature such that, when you create a pivot table with some non-numeric column, Calc doesn’t somewhat stupidly ‘guesses’ the function will be “Sum”, which is not possible for non-numeric data, but switches to “Count” instead?
Thanks for your consideration, RZ