Advanced Pivot Table Tricks ONLY Experts Know 

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?

Who told that? 100% of the businesses corporates use excel as a key software till date

I agree with you. If people take the time to learn they can get twice the work done in half the time!

It is people who don't know how to use it or bother to spend the time asking "can excel...."

Because there is PowerBI - there you can crossfilter between tables. Excel is not dynamic, it’s just a calculation tool

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.

Great to hear Aaron, thank you!

That’s great to hear Derek thank you for the nice comment 😁

Great to hear Kevin than you!

Thank you Augustin! Yes I’ve used vba a good bit. Will note it down for a future video idea!

Great to hear! Thanks for watching

Cheers!

Glad you liked it! Hahah love to hear that about my accent XD

My pleasure!

Vamos!

Glad it was helpful!

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.

Thank you!

I know! Thanks for watching

Agreed! Thanks for watching

Thanks for watching!

Great to hear!

Thank you! Noted your suggestion for a future video :)

Great idea for a video, conditional formatting is an underrated topic

It is user view for time waste, personas sales and what time line sheet shall I make ?

Coming!! Thanks for supporting Tristan much appreciated 👊

Create a column with budget and sale per product. Then check for products that you're not getting revenue

Modelling would be the same regardless of the accounting standards (IFRS, US GAAP, Indian Standards) that you use. Modelling is about being able to visualize and to explain the data to others and / or yourself in a way that makes sense beyond just showing them a bunch of numbers. Accounting standards is majorly about allowable treatment of different accounting items / components (how you come up with the figures / numbers).

Replying to seek an answer

Maybe you could perform a quick check before and after grouping

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?