Good video. Thank you. Question: in a simple pivot table with a half-dozen columns and a Grand Totals column, is there a way to move the Grand Total column to the left? (So that it becomes the 2nd column instead of the right-most column)
Great tutorial. This helped me sort and total over 8000 cells of data by department and month. It saved my sanity! Now all I need to do is figure out if I can create a pivot table that will count the non-zero cells by department and month...any tips?
When you defined a pivot range, you remove all cell references and made it pick up all data from A:V. This range when specified in a PIVOT takes into account all the blank rows which are yet to be filled but present in the sheet and these are shown as a "0" in the 1row of the Pivot. How do you take care of this?
The problem I encountered is the COUNTA. The name of the column is Number of Errors. When I selected this under Value and selected COUNTA on the dropdown, I am expecting it to ONLY show how many of the contacts have errors (the zeros and ones). Instead it calculated the total numbers of the contacts so both zeros and ones were counted. Can you help?
Hi. Just learned how to do a pivot table and have a working on. I created a Summary sheet that only includes certain data to present to my client. How do I share a link to that sheet only and not the rest of the data? I appreciate your help. Thank you
There is an option under the file tab to share and then publish to the web. From there you can choose certain sheets. Then you just provide a link which is view only!
Great presentattion concise and illustrative, thanks. two questions how many register can manage google sheets? and is it another database softwares ( Access, SQL server, ie) compatible with? If so, how can I import data from external databsse?
Thanks for the kind words. Not sure how many registers can manage. But I’m pretty sure it’ll be tough to max out. We use at work and haven’t had any issues. If you type =import into any cell you’ll get all kinds of options including HYML, sql and others. All kinds of videos on the internet about it too!
I have a pivot table on Google Docs that is not properly pulling information I have set it to obtain. How can I fix this? EXAMPLE: I have 10 tabs for different dates in January, I have combined these into 1 tab for January. I have created a pivot table that is suppose to pull the information from the combined tab. However, while it should pull all columns labeled "date", it is only pulling one date while there are several in the combined table. I have tried everything and cannot make this work. Any advice?
@@minimaggot269 that's what I did. Luckily I figured out the issue with my formula. I originally had it set up as ({sheet, sheet, etc}). This format made the sheets appear side by side rather than vertical. I altered it to {sheet;sheet;etc} and it appeared vertical. The pivot table was set up perfectly and did not have to be adjusted. It must have been a glitch from trying to pull info from multiple columns with the same header resulting in the table only pulling from one of the columns with that header. By removing the parenthesise and replacing apostrophes with semicolons, the issue has been corrected.
Again someone talking in 1.5 speed. Beside that, the intro musc waists an actually good video. Speak slowlier and take out the scary music. We are not five year olds. Then you will get a thumbs up.
Was at the point of crying. BUT you have made Google sheets and slicers a reality for me. Thank you.
This is awesome to hear! It’s why I do what I do!
Your channel name drew me to pick your video over others. Great branding. It's what I want.
Let me know if you learned something! I'd also like to know how you are using Pivot Tables in Google Sheets!
Excellent! Everything about this video is perfect. Thank you
Glad it was helpful!
Thank you, that was awesome!
Good slicer info!!
very helpful and informative. but first im gonna try!
Good video. Thank you.
Question: in a simple pivot table with a half-dozen columns and a Grand Totals column, is there a way to move the Grand Total column to the left? (So that it becomes the 2nd column instead of the right-most column)
Great tutorial. This helped me sort and total over 8000 cells of data by department and month. It saved my sanity! Now all I need to do is figure out if I can create a pivot table that will count the non-zero cells by department and month...any tips?
Awesome to hear! It’s why I do what I do! And yes. I’d recommend watching my countif video. It works in Google sheets and excel!!
thanks for making this video and sharing
#FatDad #Canberra #Australia 🦘🇦🇺🦘
Thank you Craig
Great info...Can i make pivot tables that update automatically when the data source is updated?
Hi, thanks for the video! Can you share a link to the DataSet for practice? Thanks!
When you defined a pivot range, you remove all cell references and made it pick up all data from A:V. This range when specified in a PIVOT takes into account all the blank rows which are yet to be filled but present in the sheet and these are shown as a "0" in the 1row of the Pivot. How do you take care of this?
The problem I encountered is the COUNTA. The name of the column is Number of Errors. When I selected this under Value and selected COUNTA on the dropdown, I am expecting it to ONLY show how many of the contacts have errors (the zeros and ones). Instead it calculated the total numbers of the contacts so both zeros and ones were counted.
Can you help?
Hi. Why didn't you use a slicer for the year ? much easier than changing a filter.
Hi. Just learned how to do a pivot table and have a working on. I created a Summary sheet that only includes certain data to present to my client. How do I share a link to that sheet only and not the rest of the data? I appreciate your help. Thank you
There is an option under the file tab to share and then publish to the web. From there you can choose certain sheets. Then you just provide a link which is view only!
Great presentattion concise and illustrative, thanks. two questions how many register can manage google sheets? and is it another database softwares ( Access, SQL server, ie) compatible with? If so, how can I import data from external databsse?
Thanks for the kind words. Not sure how many registers can manage. But I’m pretty sure it’ll be tough to max out. We use at work and haven’t had any issues. If you type =import into any cell you’ll get all kinds of options including HYML, sql and others. All kinds of videos on the internet about it too!
@@whyworksmarternotharder thank you so much
Great video, can you go into how to filter top 10...i.e show only top ten QB passing yard all time only in Google sheets
I might do an updated version of this video
Use query(). You can include Limit 10 in that.
@@minimaggot269 can you explain further? Is there a video on this?
I have a pivot table on Google Docs that is not properly pulling information I have set it to obtain. How can I fix this? EXAMPLE: I have 10 tabs for different dates in January, I have combined these into 1 tab for January. I have created a pivot table that is suppose to pull the information from the combined tab. However, while it should pull all columns labeled "date", it is only pulling one date while there are several in the combined table. I have tried everything and cannot make this work. Any advice?
Use Query() to construct a master sheet from the jan sheets. Then use a pivot table on the master sheet.
@@minimaggot269 that's what I did. Luckily I figured out the issue with my formula. I originally had it set up as ({sheet, sheet, etc}). This format made the sheets appear side by side rather than vertical. I altered it to {sheet;sheet;etc} and it appeared vertical. The pivot table was set up perfectly and did not have to be adjusted. It must have been a glitch from trying to pull info from multiple columns with the same header resulting in the table only pulling from one of the columns with that header. By removing the parenthesise and replacing apostrophes with semicolons, the issue has been corrected.
how do I hide the pivot table editor to manipulate and present a dashboard in a cleaner version?
Click outside of the pivot table and then close it out by clicking the X. It’ll come back when you click on the pivot table again.
Can this be used in excel also?
Yes!! ua-cam.com/video/54rcsPXmyQU/v-deo.html
Again someone talking in 1.5 speed. Beside that, the intro musc waists an actually good video. Speak slowlier and take out the scary music. We are not five year olds. Then you will get a thumbs up.