How to get multiple column values in next cells in pivot table | Excel Pivot Traditional Design
Вставка
- Опубліковано 5 лют 2025
- A pivot table is a summary of your data,that lets you report on and explore trends based on your data.
Pivot tables are particularly useful if you have long rows or columns that hold values you need to track the
sums of and easily compare to one another data points.
In simpler words, pivot tables extract meaning from that seemingly endless jumble of numbers on your screen.
And more specifically, it lets you group your data together in different ways so you can draw helpful conclusions
more easily.
The "pivot" part of a pivot table stems from the fact that you can rotate (or pivot) the data in the table
in order to view it from a different perspective.
To be clear, you're not adding to, subtracting from, or otherwise changing your data when you make a pivot.
Instead, you're simply reorganizing the data so you can reveal useful information from it.
A Pivot Table is one of the basic data analysis tools.
Pivot Tables can quickly answer many important business questions.
One of the reasons we use Pivot Tables is to pass information.
Although Pivot Tables are only tables and thus missing real visuals, they can still be considered as a mean
of Visual Storytelling.
A Pivot Table is used to summarize, sort, reorganize, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.
A simpler explanation of a pivot table can be something like this-
a) group items/records/rows into categories
b) count the number of items in each category,
c) sum the items value or compute average, find minimal or maximal value etc.
________________________________________________________________________________
In this video we have covered.
What is Pivot Tables in Excel?
How to use Pivot Tables in Excel
How to add transform data using Pivot Tables in Excel
How to add column values in Pivot Tables in Excel
How to add row values in Pivot Tables in Excel
How to get summaries values in Pivot Tables in Excel
How to apply filter values in Pivot Tables in Excel
How to remove Pivot Tables in Excel
How to change data source of Pivot Tables in Excel
How to design pivot table in excel
How to use data range from other sheets to create pivot table
__________________________________________________________________________________________________
You can follow us on the below social media handles:-
Blog: - thedatamillenn...
Facebook:- / the-data-millennials-5...
Instagram: - / the_data_millennials
LinkedIn: - / data-millennials-6b5a0...
Twitter: - / datamillennials
This was exactly what I needed, got my answer at minute 4:23 and didn't even have to watch the whole thing 🙂 THANK YOU.
This has been driving me nuts for ages! Thank you. A million times, THANK YOU!!
Hi @Clint Potts.
I am Glad that our video was helpful .
Request you to please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
For years I hate pivot tables for this and was not able found a solution - and all of a sudden I found this video - THANKS FOR IT
You're welcome!
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
I was facing this issue for long. No channel was able to give satisfactory explaination to this problem other than @the data Millennials. Thanks for this video.
Hi @ojas pimparkar,
We are happy that our video was useful for you.
I request you to please help us by subscribing our channel and sharing our channel with everyone who wants to learn something new.
I didn't know it is that simple by re-designing the pivot table format! Million thanks! I have been silly the whole time :D
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Thank you! This addressed all the issues that I was having trouble resolving!
it really means a lot to us when you guys share your thoughts with us. it encourage us and motivate us to work a lot harder then we are doing currently.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
You saved my day. Viewed many videos but could not find what I wanted. Thank you.
Glad I could help.
And I request you to please support us by subscribing our channel and share our videos among your peer groups
Hello. This just changed my whole life. Thank you so much❤😢
This was exactly what I was looking for ! perfect explanation of the main issue and also the minor issues like subtotals etc. Thanks a ton !
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thanks to you for showing it in so lucid way.
I will do it this way from now.
Thank you so much
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
this was a huge breakthrough for me - finally - thank you!!
You're welcome!
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thanks for explaining how to add the adjacent columns' information. This is exactly what I was looking for.
Hi Sarvesh Agrawal,
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Thaks a lot for this video, couldn't find what I need in other videos. Very helpful.
Hi Yendry,
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Thank you very much!
I was frustrated with the subtotal in PivotTable, your video helped me to figure it out.
it really means a lot to us when you guys share your thoughts with us. it encourage us and motivate us to work a lot harder then we are doing currently.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Oh my god, Great work man, you saved me a ot of headache,Thank you.
Hi @NBA Best Parts,
I am Glad that our video was useful and helpful .
Request you to please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
This video was extremely helpful… Thanks for the explanation
HI @Fairoos,
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Exactly what I was looking for and even more! Thank you.
Great to hear!
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
VERY HELPFUL!! FINALLY! AFTER 5 YEARS HAHA
You're welcome!
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thank you, very helpful!
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thanks a ton for your clear explanation .. Saved a lot !!
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
classic pivot table option really solved my problem , and i subscribe your channel , ok dear
Hi @NZ Karachi
I am Glad that our video is helpful .
Request you to please help us to reach out to all of those people who might want to learn something new, by sharing our content.
And Request you to please subscribe our channel and share our channel with your friends to learn more about such topics
.
@data millennials, Thank you! Your clear presentation helped me to get the exact layout I have been looking for.
apologies for the delayed response.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Very very nice dear.. i got solution..thank you so much
I am Glad that our video is helpful .
Request you to please help us to reach out to all of those people who might want to learn something by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
*In case if you are struggling with any topic, Please connect with us on the given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com*
Good explanation.. everyone who is new to excel should watch this.
Thanks for your kind word.
I request you to please support us by subscribing our channel and share our videos among your peer groups
so very helpful! Thanks so much!
I am glad that our video was useful. i would request you to please subscribe our channel to learn more stuff.
I love love love this so much ! Thank you for your video.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Straightforward. Thank you!
HI @johnpatrickhernandez.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Glad I saw this video. Thank You So Much!
Hi @carlcee
You're welcome!
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
This is really helpful . thanks for sharing
hi @Ashan eranda
I am Glad that our video was useful and helpful .
Request you to please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
When i wanted to bring in multi-dimenisonal data, it was always messy and not clear. 2 super tips and the charts are so clean now
thank you so much
Hi @Sudha Sai Pradeep.
I am Glad that our video was useful, helpful and provided what you were looking for .
Request you to please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
This was so helpful! Thank you!
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Informative 👍🏼
You're welcome!
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thank you, this has been a big help!
You're welcome!
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thank you so much, it's been taking years to know this 🥹
it really means a lot to us when you guys share your thoughts with us. it encourage us and motivate us to work a lot harder then we are doing currently.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Thank u very much, exactly what I am looking for..
HI Omm,
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Thanks for the info.
Much Appreciated Brother.
Hi @Abhishek Chandan,
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Exactly what I was looking for. You saved me a lot of time. Thanks🙏
I am Glad that our video is helpful .
Request you to please help us to reach out to all of those people who might want to learn something by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
*In case if you are struggling with any topic, Please connect with us on the given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com*
Me too. I was looking for this trick. Thanks a lot. Saved me many hours
@@jennymarin9777 I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Perfect. Exactly what I was looking for!
Thanks Gustavo. And Hope the videos are helpful.
Please help us to grow by subscribing our channel and sharing our content with everyone.
Thankuuuuu sooooo much... It is realy very useful trick... And now i am subscribing your channel😃😃
Thanks Nitesh. And Hope the videos are helpful.
Please help us to grow by subscribing our channel(in case if you have not subscribed yet) and sharing our content with everyone.
Thank you for this video!
Exactly what I was looking for...thnx
Hi Basant.
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
*And Request you to please subscribe our channel to learn more about such topics*
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
I too faced this problem, now got solution. Thanks!
Welcome Bhaiya, I hope the videos are helpful.
It was really helpful for me, i am subscribing to your channel 😊
apologies for the delayed response.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Very important question
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
This is really cool.thanks.
Our pleasure!
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
So useful!🎉
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thank you very much, it was very useful !!!
@Elena Masyuk,
I am Glad that our video was useful and helpful .
Request you to please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics.
Very helpful, thank you! This is what exactly I was looking for.
Hi @MFN ,
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
All I wanted...thankyou soo soo much sir❤
apologies for the delayed response.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Excellent Video. Practical 👏
Thanks for your response, it really encourage us to work harder.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thank you, this was a lifesaver
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Is the quality ❤ i would like to share this video every in my status
thanks Akash.
you words have really encourage me to work harder, so that i can help someone in need and I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Finally I got it👍👍👍
Hi@Naga Rajan,
I am Glad that our video was useful and helpful .
Request you to please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Extremely helpful! Thank you very much
@Renee.
Hope you are well.
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
You are the best bro, thanks
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
wow thanks a lot, this is what I was looking for!
Hope the videos are helpful.
Please help us to grow by subscribing our channel and sharing our content with everyone.
Thank you ❤😊
Thanks a ton! Helped a lot
HI @Mr.RightNow.
I am Glad that our video was useful and helpful .
Request you to please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
I was looking for this video
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thanks a lot! It's working
HI @Ashika Hedge.
I am Glad that our video was useful and helpful .
Request you to please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
life saver. thanks
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
good one
Thank you! Cheers!
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thaaaanksss! I was trying to do that.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
I spent all day yesterday doing this and literally made a whole new worksheet to compress all values and thought of creationg a new one to get the sum of all values by operator. 🤣🤣🤣🤣 I like it complicated.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Thank you so much!
Hi @Rajat Suri,
I am Glad that our video was useful and helpful .
Request you to please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Exactly what I was looking for, thank you! new subscriber 😊
I am Glad that our video is helpful .
Request you to please help us to reach out to all of those people who might want to learn something by sharing our content.
And thanks for subscribing our channel
*In case if you are struggling with it, Please connect with us on the given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com*
Very insightful...thank you
Glad you enjoyed it!
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thank you. You help me out
Hi Asisipho Guga
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
How do you do this in Google Sheets, the same format doesn't seem to work
i have used this into excel, this same format doesn't work in google sheet.
in case if you any other please feel free to contact
Excellent video, thank you
Hi @ Scoot W,
I am Glad that our video was useful and helpful .
Request you to please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thank you so much. This video has been very insightful
Hi Susan,
I am Glad that our video is helpful .
Request you to please help us to reach out to all of those people who might want to learn something by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
*In case if you are struggling with any topic, Please connect with us on the given email id and we can connect over a quick google meet call and help you to resolve it.
Thank u so much this technique helped me a lot
I am Glad that our video is helpful .
Request you to please help us to reach out to all of those people who might want to learn something by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
*In case if you are struggling with any topic, Please connect with us on the given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com*
thank you so much brother for this
really helpful
Hi himanshu,
I am Glad that our video is helpful .
Request you to please help us to reach out to all of those people who might want to learn something by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
*In case if you are struggling with any topic, Please connect with us on the given email id and we can connect over a quick google meet call and help you to resolve it.
Many Thanks...😃
Hi @Saikumar P.
I am Glad that our video was useful and helpful .
Request you to please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Great explanation, thanks! For the data I usually look at, this is nearly always how I want to display things. Is there really no way to accomplish it in "modern" layout rather than "classic"???
HI Jeff,
I am Glad that our video is helpful .
Request you to please help us to reach out to all of those people who might want to learn something by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
*In case if you are struggling with any topic, Please connect with us on the given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com*
THANK YOU!!!
apologies for the delayed response.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thank you , this is perfect
apologies for the delayed response.
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thank you so much it's helpful for me
Hi @SIVA PRASAD MAJJI,
I am Glad that our video is helpful .
Request you to please help us to reach out to all of those people who might want to learn something by sharing our content.
And Request you to please subscribe our channel to learn more about such topics.
In case if you are struggling with any excel topic , *Please connect with us on the given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com*
Thank youu so muuch!
Thanks And Hope the videos are helpful.
Please help us to grow by subscribing our channel and sharing our content with everyone.
Really helpfull! Thank you! :)
Hi Thijs,
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
*And Request you to please subscribe our channel to learn more about such topics*
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
How to break the grand total in category
thank you....it is really helpful
Hi Shwetal Shewde,
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Super thanks
You're welcome!
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Can we edit a specific cell in pivot table?
Hi Saranya,
Hope you are well.
You can not edit a specific cell of the pivot table , except the column headers of the pivot table .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
many thanks dude :D
Hi Hamza,
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
@@thedatamillennials done :D
Thanks Hamza.
Happy learning and see in the next video.
Can a column be added showing percentages if it came from a total that was derived from two columns added together? For example the table is divided into males and females. There is a total of both and then you need a separate column to display what percentage of the grand total is that male/female total column. Is that possible and if so how can it be done?
Hi @Hestia A,
Yes you can create a calculated field in which you can have the percentage of the grand total.
In case if you are struggling with it, *Please connect with us on the given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com*
Thanks a lot
HI Anil Kalsaithkar,
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
thank you sir
welcome brother
I don't see this option when I'm using Microsoft 365. Can someone help me on this
the option is present there,please go through the video again
Brilliant
Hi Mahesh,
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
hi! it's literally a video that I've been looking for to solve my problem!
there's also few thing I want to know about pivot table
1. how to make pivot table shows the category (colomn) that has no value. let me tell you the example. there's a variable X category named 1, 2, 3, 4, and I wanna show this as the column. there are 10 data on category 1, 13 data on category 2, 0 data on category 3, and 19 data on category 4.
I tried to make column based on the category, but category 3 is missing (automatically, since it has 0 value). so how can I show that category 3 on the colomn?
2. for example, we code "available" as 1, and then "not available" as 0. If we were asked to show the data of "available" we can do it by -sum of. but my second question is how should it be done if we were asked to show how many "not available" value, since we cant do -sum of, or -count of (cuz it will count the entire data)??
I tried to do -countif but pretty sure that did it in the wrong way because I didn't get the thing I want.
thank you, I really appreciate it if you could help me 🙏🏼
hey i would suggest you to drop me a note on below email id and we can get on a quick call to solve your above problems.
Email Id:- master.datamillennials@gmail.com
many thanks really helpful
Glad that the video was helpful.
And I request you to please support us by subscribing our channel and share our videos among your peer groups
Thanks alot..
HI Abhay Sharma.
I am Glad that our video was helpful .
Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Clear cut explaination
Thanks Nancy, and we are glad that you found our video helpful.
I request you to please support us by subscribing our channel and share our videos among your peer groups
Champion :)
Thanks @panesh5344
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thank youuuuuu
I am Glad that our video was useful and helpful .
Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
Thank you very much.
Welcome 😊
Very Helpful! NOW the problem is that I am not able to sort from Largest to Smallest.
HI Tom,
You can do it . But in order to sort the data from largest to smallest you have to go specially on each column and select sort by largest to smallest by selecting.
In case if you are struggling with any topic, Please connect with us on the given email id and we can connect over a quick google meet call and help you to resolve it.
Email Id:- master.datamillennials@gmail.com
Request you to please help us to reach out to all of those people who might want to learn something by sharing our content.
And Request you to please subscribe our channel to learn more about such topics
This was very helpful, thanks
Glad it was helpful!
This video was extremely helpful especially adding new columns with classic pivot table option. Can you advise if we have dates, how do we show the exact dates under each row. When I drag them under column, they change to count. Tried to change the format to date format but it somehow changes the data.
I am Glad that the Video was helpful.
If you have dates, you can put dates either in rows or column and the then select the range and change the format as date then it will not show as count(actually when you drag dates in column, it is not showing you count, it is dates but in number format, you just have to change the format).
And I request you to please support us by subscribing our channel and share our videos among your peer groups.