Want more ways to get more out of Google Sheets? Watch this playlist: kzitem.info/news/bejne/lHuXxYWOg56YgW0 Optimize your business and boost your sales with Pipedrive (get 25% off): pipedrive.thld.co/simpletivityoct
@mirrorreflection3479
4 жыл бұрын
I think everyone will agree with me that we need more videos on pivot table to familiarize ourselves as well get to see other options in Google sheets. Please like if you agree...
@Simpletivity
4 жыл бұрын
Thanks for sharing!
@hiraya5769
Жыл бұрын
Im literally hired now and only learning about this. Thank you soo much. It's such a big help
@Teholimau
3 жыл бұрын
Hi, thanks for sharing! I wonder if you could share an exercise google sheet to practice with? Perhaps the same one you used as the example in this video. Thanks :)
@MMz_AlMasri
2 жыл бұрын
+1
@japossert
2 жыл бұрын
+1
@takingcareofbiz1
4 жыл бұрын
Perfect timing! Today I need to create a pivot table in Google Sheets and didn't know how. Thanks for all the useful videos.
@Simpletivity
4 жыл бұрын
You are most welcome! So glad for the perfect timing!
@codeintherough
Ай бұрын
Moved Pivot Table From data tab to Insert tab. for those from the future
@Simpletivity
Ай бұрын
Yes, very true. Thanks for the update!
@b5lovermore
2 жыл бұрын
Most helpful pivot table tutorial I've seen on KZitem! Thanks so much!
@Simpletivity
2 жыл бұрын
Wow, thanks!
@LadyGlobalChic
Жыл бұрын
Thanks for sharing very simple and easy. Glad I found your channel 👌
@Simpletivity
Жыл бұрын
Thanks for watching! I'm so glad you found this channel as well.
@pamelalim2350
3 жыл бұрын
is there any way to sort the MMM-YYYY column accordingly or we could only sort by ascending/ descending order?
@ShowBizJunkie
11 ай бұрын
You did not start with a question. What is it you are trying to achieve? Your tutorial would be much more understandable if you give the context. In your example, the rows section is about "what you want to measure". The column specifies "whether you want to measure it across the nation, across the state or across the globe like total sales per region", the values measures the actual unknown like avg(sales), sum(sales) you pick the data you want to apply aggregate functions to.
@muhammadfaraz960
3 жыл бұрын
very useful and helpful Thank you Scott and the team simpletivity :)
@anatoliistepaniuk8217
5 ай бұрын
woudbe useful to get this dataset example available
@Simpletivity
5 ай бұрын
Thanks for the suggestion. I'll see if I can find it and share it.
@mirrorreflection3479
3 жыл бұрын
We need to do something to have more sales on the desks ;)
@Simpletivity
3 жыл бұрын
Agreed!
@rosalynhollidge6200
Жыл бұрын
Thank you, this is so helpful and clear!
@calmetosis
Ай бұрын
Can't find the Pivot option on the latest Google Sheets update... Edit: Insert > Pivot Table
@erindaseafoodsupplier7921
3 жыл бұрын
why my pivot editor does not show up ?
@laurataylor8150
4 жыл бұрын
This was very helpful! I see links all the time, but never saw an explanation for how pivot tables work.
@Simpletivity
4 жыл бұрын
All the best as you explore this essential feature!
@Jay91Byrd
5 ай бұрын
Great video this helped a lot! If only sheets could do as much as excel like create calculated fields and allow you to change field settings.
@Simpletivity
5 ай бұрын
Glad you found this video helpful! What kind of data or work do you use spreadsheets for mostly?
@matthewlay4939
3 ай бұрын
Great explanation. thanks
@Simpletivity
3 ай бұрын
You are welcome!
@MikkosFree
6 ай бұрын
What an incredibly informative video!
@Simpletivity
6 ай бұрын
Glad you think so!
@adriaflorea9848
Жыл бұрын
Wow What a tutorial. Thanks. This was very helpful!
@RedMoon814
3 ай бұрын
Thank you for the video, It was explained very well.
@Simpletivity
3 ай бұрын
Glad it was helpful!
@mahhinshahzad1273
7 ай бұрын
God this is such an amazing turtorial , Been watching an 8 course specialization and in that they made used Pivot tables 4 diffrent table but never was I able to gasp the the actual concept thank you
@Simpletivity
7 ай бұрын
I'm so glad that you found this helpful! Thanks for sharing your experience.
@tomrettig
4 жыл бұрын
Thank you! Very helpful! Question: on google sheets, once I set up my pivot table, and go back to my main sheet & update it with new values, will my pivot table update accordingly?
@Simpletivity
4 жыл бұрын
Great question. Yes, a pivot table is dynamic. So any changes you make within the selected area will be reflected in the table.
@wilmamaglapuz4010
4 жыл бұрын
Good to know pivot. Can i get a copy of the sample sheet
@parentingchildhoodocd
11 ай бұрын
Thank you so much. This was very helpful. 😀
@Simpletivity
11 ай бұрын
You are very welcome. Thanks for watching!
@ProductivePM
4 жыл бұрын
Very well done and easy to understand. I appreciate your work . . .
@Simpletivity
4 жыл бұрын
Thanks, Greg.
@AIVANJAMESBALAJONDA
8 ай бұрын
This video was super helpful. Thank you very much.
@Simpletivity
8 ай бұрын
You're very welcome!
@justsurfin5013
10 ай бұрын
Had no idea Google Sheets had Pivot Tables..neat
@allysaudya
6 ай бұрын
thanks a lot! I have an exam tomorrow about this
@Simpletivity
6 ай бұрын
You're very welcome. All the best on your test!
@zxccxz164
2 жыл бұрын
nice.....but how can you set a fields FORMATTING , ie percentage.....each time i move around my pivot table the formmating gets screwed up!!
@rickharold7884
4 жыл бұрын
Cool. I love pivot tables thx
@dangerouslygoodstorieswith9732
Жыл бұрын
This helped me finish my 2022 bookkeeping -- thank you so much!
@Simpletivity
Жыл бұрын
You are most welcome. So glad that this video could help!
@yamanimadi
3 жыл бұрын
Perfect! Thank you
@jenipherakuku7326
2 жыл бұрын
thanks, saved a life today
@SpeakToTheGame
Жыл бұрын
Hey, when I click "ADD" on any of the options(Rows, Columns, etc) I do not get a drop down, any idea why? Thanks!
@Hav3nMaina
6 ай бұрын
Thank you so much. This was so valuable
@Simpletivity
6 ай бұрын
You're so welcome! Thanks for watching!
@Nevir202
3 жыл бұрын
It's not directly related, but I have a question I'd hoped I might be able to use a pivot table to solve. Unfortunately it looks like not. I have a bunch of paired columns in my data and I want to SUMIF all of them simultaneously. Using example date, I wrote a formula to do what I want, but it's already bulky when only including three of the pairs then there are like 20: I even managed to make an array that can merge the data into two columns and then allow me to run a regular SUMIF, but then I need to have that data present somewhere in my sheet So is there a way to do this within an ARRAYFORMULA or some other function to keep things looking clean and keep the formula from being half a page long?
@abhilashmumadwar2079
Жыл бұрын
Thank you
@Simpletivity
Жыл бұрын
You're welcome
@spacefolder
2 жыл бұрын
This is an amazing breakdown.. Thank you!
@Simpletivity
Жыл бұрын
You're very welcome!
@terrafalcon9165
Жыл бұрын
Hey, loved the video, the issue I have is that my chart is not working because there are blanks in some cells, I can't figure out how to make blanks 0 on sheets pivot tables, been driving me crazy.
@andresession2235
2 жыл бұрын
That's it... Jeez man. It's all over every job I search. Great explaination! Thank you
@AnggeV
2 жыл бұрын
wow! very clear explanation! thank you! 😊
@Simpletivity
2 жыл бұрын
You're very welcome!
@sallywiebe2060
2 жыл бұрын
I'm curious where the More Sorting Options is for ways to sort by month since a basic Ascending > Descending does not put the months in order. Do you have a video or instruction for how to navigate to this? Thank you
@tripaffleck
10 ай бұрын
No "Pivot Table" under Data tab in Ggle Sheets. anymore. now what
@tripaffleck
10 ай бұрын
Pivot Tables are under the Insert tab now.
@jcepri
Жыл бұрын
Great tutorial. I had no idea what pivot tables are. FYI - the main table showed no one sold any desks, but the filter brought up these reps sold desks. :-)
@xXSummonNightXx
Жыл бұрын
Very easy to understanding!! Thank you 😊
@Simpletivity
Жыл бұрын
Glad to hear that!
@anatzamberg7471
3 жыл бұрын
Thank you. It is very helpful.
@Simpletivity
3 жыл бұрын
You are welcome!
@Keepit100Dre
2 жыл бұрын
Google sheets changed around a bit so the video may need to be updated
@Jess-kj8jx
Жыл бұрын
This is so so helpful- thank you so much!
@Simpletivity
Жыл бұрын
You're welcome, Jess!
@stri06
4 жыл бұрын
Easy to understand but no 'calculated field' overview and pivot chart?
@triciaboyd5459
2 жыл бұрын
can you highlight via custom formatting AND have an active pivot table?
@pglhonda2924
4 жыл бұрын
Need help why google sheet showing a subtract symbol in every cell, need a solution to it, how can I hide it.
@transparent91
2 жыл бұрын
Amazing work. Pivot to you!
@Simpletivity
2 жыл бұрын
Thanks a lot!
@mwwhatever
3 жыл бұрын
Is there a tutorial video that includes links for the sheet that you're working on?
@MarcCastellsBallesta
4 жыл бұрын
Great! Learning what are pivot tables was in my todo list. Not anymore! Now I just need to see if & how I can use them with my sheets.
@panama1942
3 жыл бұрын
When I use Sheets the pivot table option is under Insert. Did they just change that?
@friendzhub
2 жыл бұрын
I do not have the option of pivot table in DATA tab. any reasons why?
@davidjackson7675
3 жыл бұрын
How can I pivot a table longer i.e. one row for salesperson and each item?
@sandipkhelukar1816
2 жыл бұрын
Empty cell me zero kaise add kare
@pjavier
2 жыл бұрын
Hi. Thank you very much for the video, it helps a lot. Just for you to know that for some reason now the Pivot Table is in insert and not in Data.
@frantz1976
Ай бұрын
awesome video
@MrMosoani
3 жыл бұрын
I like to have the pivot table on the same sheet and not creat a new sheet is that possible?
@somanathbiswal6725
3 жыл бұрын
How to hide editor and move around the pivot table????
@heiroot
Жыл бұрын
Thank you so much!
@Simpletivity
Жыл бұрын
You're welcome!
@fatemajowarder1736
8 ай бұрын
Thank you. Simple and awesome!
@rohanayush
3 жыл бұрын
Really helpful. Thanks :)
@Simpletivity
3 жыл бұрын
You're welcome!
@Anikvikram
2 жыл бұрын
Thank you for the valubale information.
@jainnitin640
2 жыл бұрын
Can I keep the filter as a slicer on the head of the Pivot?
@PDCRFoundation
2 ай бұрын
No
@spacewar
3 жыл бұрын
Grand total is always empty for me.
@REEL_TROLLAN
2 жыл бұрын
How to change that blank cells to zero
@Italjamer
3 жыл бұрын
Thank you so much!
@Simpletivity
3 жыл бұрын
You're welcome!
@madangel676
Жыл бұрын
How to do If i need to add text in values?
@rachelrafael8002
2 жыл бұрын
hey , if i dont have that option ? how can i add it ??
@munawarhussain1400
3 жыл бұрын
How i can hide or lock pivot table editor?
@alamgerhossain8069
2 жыл бұрын
Many Many Thanks
@Simpletivity
2 жыл бұрын
Many many welcomes!
@erey9230
2 жыл бұрын
Do you know how to get rid of the #DIV/0!
@marinadanilina3275
2 жыл бұрын
I have two two versions of Excel 2013 and Microsoft 365 and neither one of them has the option in Data tab. I have Pivot Table in Insert tab. What version do you use?
@Simpletivity
2 жыл бұрын
This tutorial is for Google Sheets.
@marinadanilina3275
2 жыл бұрын
@@Simpletivity Thank you
@BarkatulAlam
3 жыл бұрын
Fantastic Love this video..
@MrLithuanian91
Жыл бұрын
thanks very helpful
@gwendolyngilleyconstructio3265
2 жыл бұрын
its not there anymore
@carlisefarren4236
2 жыл бұрын
Great video
@aatifrashid5413
2 жыл бұрын
Perfect!
@NemesisConfirmed
3 жыл бұрын
Lol
@rohitbhargava2648
Жыл бұрын
Pinpoint explanation to every thing important, even you will wonder that 9 minutes are already over. Nice exercise! 👌👌
Пікірлер: 126