We take a look at one of the most powerful, but somewhat frightening, features of modern spreadsheets. But knowing the basics of pivot tables should make them a bit less frightening to the newcomer.
CommentsSubscribe to the comments RSS feed.
Comment #1 posted on 2015-01-18T12:30:21Z by Steve Bickle
What version of LibreOffice was the example created in?
Thats a really clear explanation of pivot tables, I'm sure I'll find a good use for these at some point. Thanks.
When trying to create a pivot table on the sample sheet you provided, It resulted in #VALUE errors in the totals of the resulting table. So I updated to the latest version of LibreOffice. I still had the same problem.
So then I then use a clean sheet with the data-set from sheet 1 of your example, then pivot tables worked fine as you described.
Hence the question about what version of LibreOffice was the sheet created with?
I ask because there may be a compatibility bug between versions that I should report.
Comment #2 posted on 2015-01-18T12:33:47Z by Steve Bickle
Last comment really belongs on ep 1655
Comment #3 posted on 2015-01-19T19:48:00Z by Kevin O'Brien
It was 18.104.22.168. I know that is not the most current version, but I do
these in advance and schedule them out.