Dude, I have tried Google and AI differently for hours, couldn't figure this out. Thank you so much!

2 hours looking for an answer in many forums and i found this video, thank you! lifesaver.

Very helpful as always! Thank you, Sir!🙏

Thank you so much for this demonstration. It worked PERFECTLY for what I needed. Again - Thank you so much!

@chandoo_

3 жыл бұрын

Glad it helped!

Awesome!! Exactly what I was looking for. 🤜🏾🤛🏾

It worked!! Thanks for explanation.

I used it for a slightly different purpouse, but what you explained helped me effectively. Thanks man!

@chandoo_

3 жыл бұрын

Glad it helped!

awesome tip worked perfectly thanks

Very useful! Thanks a lot :-)

Thanks!

One million Thanks after struggling for weeks found home in your soln... Pranam...Thank you chandoo!!

@chandoo_

2 жыл бұрын

Always welcome

This is really helpful. Can you also explain how 1 value can be displayed as a ratio of the other.

Thank you!!!

Good one. Thanks

Hey, what if I have two columns, January and February. I guess I need additional calculate filters but I couldn't figure out, can you help me?

What if I want to divide by Grand Total's value, how do I return that value into formula?

Hi chandoo is there a way to add a new line under the subtotal which will do a custom calculation for a single variable and others won't have any calculations

Thank you so much 🙏🏻🙏🏻

@chandoo_

2 жыл бұрын

You are welcome Melissa... :)

very helpful, thank you for sharing!

@chandoo_

4 жыл бұрын

Glad it was helpful!

Gr8!

Nice lesson. If you will send this file and it will be opened by another user excel without powerpivot, will the calculations and results be affected?

Hi, Thanks for the video, getting range & table instead of data in power pivot, to add additionally formula please help, Thanks in advance

i want to create a price list and have 1 box that i can put a tax percent in and all price change to that percent. anyone knows how to do so ?

How to do the % calculation on month on month, can you show that in video

Hi please assist How to subtract sales total from purchase total?

Hi if I want to find YOY and MOM how do I do so?

Chandoo it’s really helpful. But DAX formula looks too complicated.

@chandoo_

6 жыл бұрын

Don't be hesitate to learn DAX bro. It is a very powerful and extremely useful technology. Once you overcome initial hump, it will reward you handsomely.

Hello, Your video is very useful but i have a situation: on columns i have months and i have different cost centers. I need excel to calculate the percentage of costs on the total sales of each cost center, per each month. Can you help me? Thank You!

@chandoo_

3 жыл бұрын

Sure... Can you email me sample data at chandoo.d@gmail.com?

@christophertrahan4401

3 жыл бұрын

Did you get your reply? I have a similar issue

@ramonat5160

3 жыл бұрын

@@christophertrahan4401 Yes, this is the formula that worked in my situation: =sum(Range[VALUE])/ calculate(sum(Range[VALUE]),all(Range[BUDGETLINE]), Range[TYPE]="SALES")

that's so so sad the trick doesn't work for Mac! :(