Sir we are learning many things from your video however i have to know 2 things. 1st i have big data with approx 100 items and 150 sales areas so i want to make pivot table bar chart with scroll button and spin button. 2nd I have to see 1 item sales % in whole sales of stationary shop. example my total sales is of Rs100 for all items including of pen sale of 15 Rs. i will select pen to know the sale data of pen. this show pen sale data. but i want to know when i select pen it also shows how much % of sale of this pen is in total sale of 100. coz when i select pen it shows 100% in pie chart pen sale which i dont want. Show less Sir we are learning many things from your video however i have to know 2 things. 1st i have big data with approx 100 items and 150 sales areas so i want to make pivot table bar chart with scroll button and spin button. 2nd I have to see 1 item sales % in whole sales of stationary shop. example my total sales is of Rs100 for all items including of pen sale of 15 Rs. i will select pen to know the sale data of pen. this show pen sale data. but i want to know when i select pen it also shows how much % of sale of this pen is in total sale of 100. coz when i select pen it shows 100% in pie chart pen sale which i dont want.
At 4:28, how would you take the Total of the Top Ten as a percentage of your Grand Total for all states? Would you just reference off of the [unfiltered] Master Table or is there a better way?
BC there are competing software alternatives out there. I interned at a facility that knew they needed a Data Analyst. They spent so much time and money having a Tableau account no one knew how to use. The DA was hired, I had a conversation about a small data project that I was using Power Query for and uploaded to Power BI for visuals. She looked at me with so much confusion bc she said she didn't use Excel much, she used Python, wasn't familiar with Excel PQ either. I merely asked the VP why the company was spending much more with Tableau instead of just using Power Query/BI. Understanding they could get the same results at a cheaper price, their realization was obvious. Of course each have their nuances, but how DAs are trained and what platforms are used, is a matter of competition. Having multiple knowledge application of all these platforms and understanding their differences can save companies time and money. It also requires continuous learning as the competition continues to provide updates too.
I wish you were a professor at an Undergrad Business school. These things are 100% more important than anything I learned in school. After being in the working world for + 15 yrs techy people are great in finance - not the pure finance geeks. Techies make the best files, macros and excel models and everyone deems them the "gods" of finance.
"Kenji, thank you so much Your explanation was exceptionally clear, and it made it much easier for me to understand the topic. I appreciate your help."
Nicely explained Kenji, been using excel a long time, always more changes on new updates. Always learning, like a lot of people. Just came across your channel by chance and now subscribed too. Thank you!
Best mentor ever for working professional....thank you for sharing valuable information...most effective part is you cover topic in short time.Kudos to you
In the section with the dynamic pivot table chart, where you are filtering by product, how do you show a chart where you can show total units sold by price range for the different products (i.e., not the sum of both women's + men's apparel, but two different bars showing the units sold in each price range for these different product types)?
The grouping units feature redundant endpoints, e.g. 40, 60, 80, etc. appear twice. Thus the viewer can't know if a $40.00 entry has been grouped in the 20-40 or the 40-60 bin. This suggests a round-off issue in which a value such as $40.50 may have in effect fallen between two bins, which work with integers.
These are the best videos I have seen so far, thank you. I have one question though, does anyone knows how to permanently fix the dimensions of the Pivot table and Chart that they don't resize and/or move during filtrations? Especially their width and if possible their heights? Thank you.
Great course as always, almost 100k congrats for this whole entrepreneurial project that seems to thrive (Ytb channel, Excel course you created etc). If you have the knowledge for that, could you please do the same format video for VBA ? I think it could help almost as many people as for Excel.
I love the "Report Filter" functionality - I only have an issue; I would need to keep the Conditional Formatting created in the original Pivot (i am using Icons to signal visually if a course is complete, in progress or only enrolled) - is it possible?
I didn´t understood well the region part and the cells arrangement , from who come that layer for ? What is the sheet for , for sales because I have no idea about it.
Great video as always with lots of handy tips. But at formatting I have a question. I guess it is simple, but why the accounting format and not just the financial formatting?
I subscribed ur channel couple of days ago and loved the way u explain since then i have been watching ur videos…. Can u please make an detailed advance level file on conditional formatting plz and if u have make one can u plz share the link thanks and u r doing a great job.
Use Case: I have a pivot table connected to splicers. The pivot table has 20 rows of data and multiple columns. The splicer filters between Fiscal Quarters. Is there a way to set up excel or pivots to not truncate the rows I apply a filter? For example...I have 20 rows when in Q1, but when I apply the filter for Q2 it goes down to 15 rows...hiding rows without data. Can I set up the pivot to keep the 20 rows and show rows without data as blank?
hello, thanks for the information, query: how can I select in a drill down the number of columns that I want to show in the new sheet. If the base data has many columns, perhaps not all of them are of interest in a drill down, thank you very much in advance
hey sorry but I wanna ask something at 0:35 how can you change the header automatically from alphabets to text like that? I would be gratefully happy if you can explain it tho, cause it looks so useful😆
Just one doubt: When grouping price ranges within intervals, for those products that cost exactly $40,00, would go on to the 20-40 or the 40-60 interval? It would be useful to be able to do something like 21-40 and 41-60
I've got no idea, but if I had to guess since we started from 0 then maybe it's 0.00-19.99 but I really need to double check. Did you find the solution?
How can we update automatically pivot tables when we add some datas inside of our source table? I don’t wanna use refresh it every minutes or open the workbook options. May you help me about this question?
Dear Kenji, can you share ideas in which ways we can do product analysis of a Company. We have many products and our Management wants to know which product we should continue and which one to discontinue selling. How can we make this decision. Please share your thoughts.
Kenji, when I refresh the pivot table The field filter disappears and the data for all years are displayed, Can you help trouble shoot this type of error? Thanks, Ed
If yu are business analyst with that vocabulary than I am the president of US. The stupidity have no limits. But you can talk anyway, you can copy-paste like a parrot everything you see-.Remeber that you are mental ill.
Could someone explain to me how to do it, to the value to be changed in all pivot table column, since my excel does it only for the cell chosen (1:14) :/ Of course, I know it can be done by choosing all the area, but I would like to fix it that it orks the same as in the video.
I HAVE A PIVOT TABLE. IN THIS TABLE IN THE TOP ROW & COLUMN 1 IS THE DATE RANGE AND I WANT TO USE THIS DATE RANGE COMMAND WITH VBA USER FORM. WHEN IN USER FORM I CHANGE THE DATE AND CLICK ON SHOW IN USER FORM THEN PIVOT TABLE TOP ROW & COLUMN 1 IS THE DATE RANGE IS AUTOMATIC CHANGE AND UPDATE WITH DATE DATA. IF IS IT POSSIBLE ??? PLEASE RESPONSE ME. AND MAKE A VIDEO ON IT. THANKS (AMARENDRA KUMAR)