I have a spreadsheet
A | B
-----------
alice | 100
bob | 100
carol | 200
dave | 100
edith | 200
I want to basically count(*) group by B
, the result being
100 | 3
200 | 2
How to do this in LibreOffice?
I have a spreadsheet
A | B
-----------
alice | 100
bob | 100
carol | 200
dave | 100
edith | 200
I want to basically count(*) group by B
, the result being
100 | 3
200 | 2
How to do this in LibreOffice?
Create a pivot table with column B in the "Row Fields" and in the "Data Fields" list; double-click on the "Data Fields" entry "B" to change the default SUM function to Count:
Result: