Ahuka,

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.

Steve