Description: The default "Data Field" is Sum. This results in empty cells if the data are strings. A better default would be Count. This is the default in Excel and it's more sensible. Steps to Reproduce: 1. Select a data of strings 2. Insert Pivot Table 3. Drag "Available Fields" to "Data Fields" Actual Results: Nothing in the cells Expected Results: If the default were changed to count, the cells would have the count. Reproducible: Always User Profile Reset: No Additional Info: You could say it's a design issue, not so much a bug, but for me it's serious enough that I wouldn't recommend LibreOffice Calc to my students for Pivot Tables.
I don't like this idea
Heiko, one for UX? -1 from me, as I'm really angry when working in excel with pivots and need to change Count to Sum. Usually I'm working with numbers and I want sum numbers..
(In reply to raal from comment #2) > Heiko, one for UX? Feel free to add keyword/CC at any time. > -1 from me, as I'm really angry when working in excel with pivots and need > to change Count to Sum. Usually I'm working with numbers and I want sum > numbers.. Maybe, but the request makes sense too. So how about storing the last used value?
(In reply to Heiko Tietze from comment #3) > (In reply to raal from comment #2) > > Heiko, one for UX? > > Feel free to add keyword/CC at any time. > > > -1 from me, as I'm really angry when working in excel with pivots and need > > to change Count to Sum. Usually I'm working with numbers and I want sum > > numbers.. > > Maybe, but the request makes sense too. So how about storing the last used > value? Moving to NEW then...
What could be fine it's sum default for fields with numbers and count for fields with string or dates. Otherwise, no change default.