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
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
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?
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?
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..
@@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.
Fantastic guide sir! Certainly beats the horrible Calc instruction manual. Thanks again for taking the time to do this.
Cool 😎 thanks 👍
Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm
I didn't know how to do this. Thank you! Your tutorial is very easy!
Cool :)
Very good explanation, thank you! Learn some new today.
Thanks 👍
Fabulous.. Thank you very much..
I was wondering about this since morning.. Your video helped me a lot.
Keep up the good work.
Thanks 👍
Would be awesome if you can give me a Google review to help my business 👍
g.page/dcpweb/review?gm
This is really helpful. Thank you for providing this tutorial. Your explanation is really good.
Thanks 👍
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
Great tutorial Sir! Grateful for teaching me.
Thanks 👍
Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm
9:15 ah, nice trick i could use
Great 👍
Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm
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.
Thanks, data is the columns or content selected in the spreadsheet
@@dcpwebdesigners Yeah but in the other pivot tables, you deleted that "Data" and didn't use it. I'm confused.
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
Please check help.libreoffice.org/Calc/Creating_Pivot_Tables
Saved a huge time for me.
That's great 😎
Thank You that was a great tutorial!
Thanks 😊
Thank you so much!
No worries!
Very useful tutorial! Thanks
Thanks 😎
Do you know if it's possible to do calculated fields other than manually doing?
Thanks for the vids
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
Thank you. Very helpful.
Thanks 😎
Useful video... Ty
Thanks 😎
Hi, Can you let me know, How to apply Pivot table through Macro in the Libre office?
Sorry not sure
thank you
Cool 😎 thanks 👍
Also check out my new blog for more free tutorials www.dcpweb.co.uk/blog
Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm
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?
Hi, I have uploaded spreadsheet here: www.dcpweb.co.uk/blog/libre-office-pivot-table-tutorial
Awesome! Many thanks.
That was helpful, thanks
+gms9810 thanks :)
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?
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..
@@dcpwebdesigners Thanks, appreciate.
very helpful
+Tanmoy Barik cool :) thanks !
How to creat calculate filed in pivot tabel in libre calc plz suggest
im trying to format my inventory into a table saying error to much information maybe? or same items over and over again?
Might be cell format error
how can i unhide the column in the libreoffice excel ??
Left click in top left corner to select all cells in spreadsheet, right click on any column letter and then select show option
thanks man :)
Cool 😎 thanks 👍
👍👌
😎👍
I use calc because I can't afford Excel.
Yes calc is good software 😊
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!
😂
how to create a second pivot table in same sheet?
@@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.