Thanks Celia, For your valuable feedback and your support to my channel. Please share this with your friends and colleagues whoever is looking for excel and vba tutorials. Thanks once again for watching
Dear PK, your ideas and your explanation is excellent. I have been benefitted a lot . I want to ask you one thing. How to use slicer when there are two or more date fields in the data table. Suppose a target date and a compliance date. Please throw some light on this too.
Thank you for such a wonderful information. Please tell, if sales consists multiple columns, like sale, discount, some other column. As it allows only one column
Dear Priyendra, just beautiful. I have a different scenario and would appreciate your guidance/tip: I have 4 different pivot tables which I need to present as pivot charts. 1) I can show only 1 chart at a time. The numbers of rows and columns change according to slicers (this is why I cannot apply the way you show in this video). Thank you, Tamir
Sir, my manager wants me to add quality chart also along with productivity chart. Please if you can also show that example in this same chart type. And aap kabhi formula explain nahi karte kyon? Please do that also jaise is video me aapne formula bilkul bhi explain nahi kiya hai. Aur sir aaj kal BPO industry me sirf productivity and quality ki baat hoti hai please apne videos ko usi hisaab se banaya karen. I am a big fan of your teachings
Thanks for the awesome tutorial 🙏 ! Question, instead of creating a chart, how can I create a table instead? How do I modify the “sales” formula column under pivot tab to a range in creating my table instead of chart?
Can we make different types of drilled down chart for a data set? For example: with your data set year wise chart will pie, then when click on one year bar chart should populate for quarter, then line chart for month like this.
Dear priyendra, I used to follow ur videos. This is really good scenario, and thanks for that. I have a small doubt, what if we have different data other than year, month, quarter and date. Can we use same formula according to the data.
Sir, In this video you have used a formula which i did not understand....First Column Last Row XVALUE Production Chart Title Can you please help me to understand.....Secondly, please create an another video about what are the basics of chart like x value, y value, Chart Area etc......plzzzzzzzzzz
Hello this is a great tutorial and very helpful. When I can creating the same pivot on date / week with sales (last pivot in the example) it's giving me trouble, it's automatically grouping by Year, Quarter and Month and even after removing them row section of the pivot still data is not coming as date format it's coming in Month format, can anyone help me with this? WHy is it happening?
Sir, How we can do the function similar to Indirect function in Excel, in power BI. For Ex. I am having a slicer with the name of all Indian states, If I don't select any thing from slicer, then in the table for ROW value , name of state should come and their population. If I select any state from slicer , then in the table, respective district list should appear and there population. Thanks in advance.
Congratulation Friends youre the Better from Venezuela go on. Thankyou for the magic of the chart
Thanks for your valuable feedback
This is one of if not the most thorough explanation of anything related to excel I've ever seen. Keep up the good work, thank you!
Most welcome
Best tutorial ever! Thank you so much
Most welcome
Man you are a genius!! Thank you so much for sharing your knowledge
Thanks for your valuable feedback
Wonderful PK
Clear explanation
Thank you
Thanks for your valuable feedback
Super amazing. I don't know Excel can do like this before.
Thanks for your valuable feedback
Dear Priyendra, it is a delight to watch the smart processes you put in place. Thank you so much for all that you teach.
Thanks Celia,
For your valuable feedback and your support to my channel.
Please share this with your friends and colleagues whoever is looking for excel and vba tutorials.
Thanks once again for watching
This video is trurly a masterpiece. I've even made a drilldown stack bar.
Thanks for your valuable feedback
Simply Excellent...👍👍👍
Thanks for your valuable feedback
Dear PK, your ideas and your explanation is excellent. I have been benefitted a lot . I want to ask you one thing. How to use slicer when there are two or more date fields in the data table. Suppose a target date and a compliance date. Please throw some light on this too.
Great... Thank you so much for this video
Thanks for your valuable feedback
Great tutorial. It's only problem is the 12 commercial breaks in the 15 minute video. Excessive.
Это невероятно !!!! Спасибо)
Excellent sir👌👌👌
Thanks for your valuable feedback
Wow excellent PK
Thanks for your valuable feedback
Wow... Hebat. Saya suka... 👍👍👍
Thanks for your valuable feedback
Great 👍 job dear , I love you ❤️😘💕
Thanks for your valuable feedback
Now I followed, I want to learn more like this type of knowledge from your channel
Oh dearie me, this is so wonderful, thang you brother!
Thanks for your valuable feedback
First time I'm commenting for a video, impressed a lot and I like your uploads . Simply superb👍👍👍
Thanks Aravinda, for your valuable feedback.
Great sir very helpful video its Amazing
So nice of you
Thank you for your work. Look forward to watching more videos from you.
Thanks for watching
Wow amazing ......... Superb ..............
Thank you for such a wonderful information.
Please tell, if sales consists multiple columns, like sale, discount, some other column. As it allows only one column
Extremely useful. Big thanks!
Thanks for watching and sharing your valuable feedback
Dear Priyendra, just beautiful.
I have a different scenario and would appreciate your guidance/tip:
I have 4 different pivot tables which I need to present as pivot charts.
1) I can show only 1 chart at a time.
The numbers of rows and columns change according to slicers (this is why I cannot apply the way you show in this video).
Thank you,
Tamir
Really you are an expert.
Thanks for watching and sharing your valuable feedback
Sir, my manager wants me to add quality chart also along with productivity chart. Please if you can also show that example in this same chart type. And aap kabhi formula explain nahi karte kyon? Please do that also jaise is video me aapne formula bilkul bhi explain nahi kiya hai. Aur sir aaj kal BPO industry me sirf productivity and quality ki baat hoti hai please apne videos ko usi hisaab se banaya karen. I am a big fan of your teachings
Awesome Bro.
I work in planning & analysis team. It is really useful and many thanks.
Thanks for your valuable feedback
First class sir , awesome..
Thanks for your valuable feedback
Awesome tips! You are a champ!
Thanks for watching and sharing your valuable feedback
Amazing!
Thanks for your valuable feedback
Thanks for the awesome tutorial 🙏 ! Question, instead of creating a chart, how can I create a table instead? How do I modify the “sales” formula column under pivot tab to a range in creating my table instead of chart?
Beautiful
Thanks🙏
Hi excellent video, but I am facing issue while making graph and link between... can u pls guideme
Simply Amazing!
Thanks for your valuable feedback
Its really amazing....but I didn't found the google drive url in below comments
Amazing videos... thank you
Thanks for watching and sharing your valuable feedback
excellent dear
Thank you! Cheers!
A very cool and good way to explain dynamic charts sir ji😁😁😁😁😁
Thanks for watching and sharing your valuable feedback
Dear Priyendra, Thanks for your awesome knowledge. I just want to know what if i have more than 1 data. can you please share the excel
Can we make different types of drilled down chart for a data set? For example: with your data set year wise chart will pie, then when click on one year bar chart should populate for quarter, then line chart for month like this.
Thank you very much for the trouble you took
Thanks for watching and sharing your valuable feedback
Waw top top
Thanks for your valuable feedback
पी के सर आप फॉर्मूले को भी एक्सप्लेन किया किजेजये। बहुत मुश्किल फार्मूला है इसमें
Great work. Thanks
Thanks for watching and sharing your valuable feedback
PK: An Excel Expert u r welcome
Dear priyendra, I used to follow ur videos. This is really good scenario, and thanks for that.
I have a small doubt, what if we have different data other than year, month, quarter and date. Can we use same formula according to the data.
Hi Siva,
Thanks for your valuable feedback. You can use any hierarchical data. This was just an example with year, qrt, month and week
excellent trick
Thanks for watching and sharing your valuable feedback
Sir, In this video you have used a formula which i did not understand....First Column Last Row XVALUE Production Chart Title
Can you please help me to understand.....Secondly, please create an another video about what are the basics of chart like x value, y value, Chart Area etc......plzzzzzzzzzz
Hello this is a great tutorial and very helpful. When I can creating the same pivot on date / week with sales (last pivot in the example) it's giving me trouble, it's automatically grouping by Year, Quarter and Month and even after removing them row section of the pivot still data is not coming as date format it's coming in Month format, can anyone help me with this? WHy is it happening?
I am getting the same problem, @PK can you help for this?
Sir, how the same can be done in power BI
Yes, we can do
@@PKAnExcelExpert Please Sir, share how it can be done.
Sir, How we can do the function similar to Indirect function in Excel, in power BI. For Ex. I am having a slicer with the name of all Indian states, If I don't select any thing from slicer, then in the table for ROW value , name of state should come and their population. If I select any state from slicer , then in the table, respective district list should appear and there population.
Thanks in advance.
Sir apne 4 slicer per kam kiya hai is se zada ho tu kese kam karenge
You can use the same method or you should use Power pivot. Please watch below given video:
th-cam.com/video/NZt65lxQ0v0/w-d-xo.html
Popcom 🎉❤🎉 silençe you 🎉❤❤❤❤❤❤❤❤🎉
how to download this practical excel file
Download link has been given in videos description box or visit our website www.pk-anexcelexpert.com
Followed step by step ( even column number same)
But my "first column" formula not working it is returning 9 only
No change is happening
Pls help
How to show this in percentage?
Hello pryedra i like your videos thank you for videos.i want to ask a question.
How can i do a graphic in userform using vba
Thanks for watching and sharing your valuable feedback. I will create the videos for graphs on user form very soon.
I tried doing this pivot. My month slicer is sorted. Its not in order but sorted A to Z
Sir why the first coulm coming noumer 13
This is a drill down of the timelines only..where is the drill down for row label data?
Its coming like this:
Week (All)
Years Quarters Date Sales1
2015 125486
2016 146819
2017 145633
I can not get pivot table
hello everyone
Dear sir... how to contact you sir pls help me