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..
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?
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
@@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 :)
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
Very good explanation, thank you! Learn some new today.
Thanks 👍
This is really helpful. Thank you for providing this tutorial. Your explanation is really good.
Thanks 👍
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
Saved a huge time for me.
That's great 😎
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
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.
Thank You that was a great tutorial!
Thanks 😊
Very useful tutorial! Thanks
Thanks 😎
Thank you so much!
No worries!
Hi, Can you let me know, How to apply Pivot table through Macro in the Libre office?
Sorry not sure
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.
Thank you. Very helpful.
Thanks 😎
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
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
How to creat calculate filed in pivot tabel in libre calc plz suggest
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
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
That was helpful, thanks
+gms9810 thanks :)
Useful video... Ty
Thanks 😎
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
very helpful
+Tanmoy Barik cool :) thanks !
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.