1
vote
1answer
141 views

LibreOffice pivot: How to count 1 per line?

I have a list of fruit occurrences like this: banana banana apple orange apple And I want LibreOffice to give me a number of occurrences per fruit, for instance: banana | 2 apple | 2 orange | 1 ...
1
vote
1answer
3k views

LibreOffice pivot table group by month

Im having data like this: Date Customer Amount Month 09-01-12 A 20 =A2 (formatted so it shows month name) 10-01-12 B 10 =A3 (formatted so it shows month name) ...
2
votes
0answers
163 views

How do I capture filter information from a DataPilot table?

In OpenOffice Calc, how do I capture filter information from a DataPilot table? Specifically, I have a DataPilot table which I graph on a chart, filtering on a field not appearing in the table. I ...