[@daverage4729]

Fantastic guide sir! Certainly beats the horrible Calc instruction manual. Thanks again for taking the time to do this.

[@dcpwebdesigners]

Cool 😎 thanks 👍

[@dcpwebdesigners]

Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm

[@danieldaanna]

I didn't know how to do this. Thank you! Your tutorial is very easy!

[@dcpwebdesigners]

Cool :)

[@SlaveToMyStomach]

Just found your void. Very good explanation, simple and clear.

[@dcpwebdesigners]

Thanks 👍

[@fishfamily8747]

This is really helpful. Thank you for providing this tutorial. Your explanation is really good.

[@dcpwebdesigners]

Thanks 👍

[@michalkolenda3396]

Thank you so much!

[@dcpwebdesigners]

No worries!

[@60sTango]

Saved a huge time for me.

[@dcpwebdesigners]

That's great 😎

[@bluemaxcnc4749]

Thank You that was a great tutorial!

[@dcpwebdesigners]

Thanks 😊

[@davidgarcan]

Very useful tutorial! Thanks

[@dcpwebdesigners]

Thanks 😎

[@brentsandiwiebe7471]

Thank you. Very helpful.

[@dcpwebdesigners]

Thanks 😎

[@dhruv043]

Fabulous.. Thank you very much..
I was wondering about this since morning.. Your video helped me a lot.
Keep up the good work.

[@dcpwebdesigners]

Thanks 👍

[@dcpwebdesigners]

Would be awesome if you can give me a Google review to help my business 👍
g.page/dcpweb/review?gm

[@gms9810]

That was helpful, thanks

[@dcpwebdesigners]

+gms9810 thanks :)

[@tiaussardar8192]

Great tutorial Sir! Grateful for teaching me.

[@dcpwebdesigners]

Thanks 👍

[@dcpwebdesigners]

Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm

[@AslanTamjidi]

Useful video... Ty

[@dcpwebdesigners]

Thanks 😎

[@realgamer1998]

very helpful

[@dcpwebdesigners]

+Tanmoy Barik cool :) thanks !

[@IvicaAnteski]

thanks man :)

[@dcpwebdesigners]

Cool 😎 thanks 👍

[@h7opolo]

9:15 ah, nice trick i could use

[@dcpwebdesigners]

Great 👍

[@dcpwebdesigners]

Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm

[@egliptor]

Do you know if it's possible to do calculated fields other than manually doing?
Thanks for the vids

[@dcpwebdesigners]

Sorry not sure, I normally setup formulas manually and then copy as required.
have fun 👍
Would be awesome if you can give me a Google review to help my business 👍
g.page/dcpweb/review?gm

[@taraknathsam4572]

How to creat calculate filed in pivot tabel in libre calc plz suggest

[@rifaeeehaimed3635]

I have Liber Office on Mac. I couldn't delete Date from the pivot table
Also, I need to get different colors for the results
Thanks so much

[@atularora11]

thank you

[@dcpwebdesigners]

Cool 😎 thanks 👍

[@dcpwebdesigners]

Also check out my new blog for more free tutorials www.dcpweb.co.uk/blog

[@dcpwebdesigners]

Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm

[@meanmeanpt]

Hi, looked for the spreadsheet data and can't find it neither here neither on the dcpweb page of this tutorial. Could you provide the corresponding link?

[@dcpwebdesigners]

Hi, I have uploaded spreadsheet here: www.dcpweb.co.uk/blog/libre-office-pivot-table-tutorial

[@meanmeanpt]

Awesome! Many thanks.

[@IvansPersonal]

This is an awesome tutorial. Thank you very much. But what is "Data" in the Column Fields here at @8:50 ? Thank you very much.

[@dcpwebdesigners]

Thanks, data is the columns or content selected in the spreadsheet

[@IvansPersonal]

@@dcpwebdesigners Yeah but in the other pivot tables, you deleted that "Data" and didn't use it. I'm confused.

[@dcpwebdesigners]

Honestly I made that tutorial over 4 years ago and I don't remember all the steps, you will need to watch carefully and read a little documentation on libre office

[@dcpwebdesigners]

Please check help.libreoffice.org/Calc/Creating_Pivot_Tables

[@Tomuntaken]

Ok, question: If one big pivot table is created (as in 9:10) and you select from it data for chart, and generate that chart, then if you change sorting or data range from dropdown menu of this pivot table, what will happen with chart?

[@dcpwebdesigners]

Good question, answer not sure, but if you want the chart to be static then copy the data to a new sheet then make the tables I will do a test when I get some free time as well..

[@Tomuntaken]

@@dcpwebdesigners Thanks, appreciate.

[@behappycool8576]

Hi, Can you let me know, How to apply Pivot table through Macro in the Libre office?

[@dcpwebdesigners]

Sorry not sure

[@kimmoon28able]

im trying to format my inventory into a table saying error to much information maybe? or same items over and over again?

[@dcpwebdesigners]

Might be cell format error

[@jayPatel-zu2rc]

how can i unhide the column in the libreoffice excel ??

[@dcpwebdesigners]

Left click in top left corner to select all cells in spreadsheet, right click on any column letter and then select show option

[@Onkarr]

👍👌

[@dcpwebdesigners]

😎👍

[@uttamprakash4309]

I use calc because I can't afford Excel.

[@dcpwebdesigners]

Yes calc is good software 😊

[@SmallGuyonTop]

Why are you SLAMMING the keyboard. It is quite offensive. Back off the keys abuse. It seems to only be on the ENTER key. CALM DOWN!

[@dcpwebdesigners]

😂

[@cristinabianes]

how to create a second pivot table in same sheet?

[@dcpwebdesigners]

@@cristinabianes I don't think that is possible as the pivot table is used to analyse the data set. You can only the data to a separate tab sheet in the same document and run a different pivot table.