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
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!
@@christophertrahan4401 Yes, this is the formula that worked in my situation: =sum(Range[VALUE])/ calculate(sum(Range[VALUE]),all(Range[BUDGETLINE]), Range[TYPE]="SALES")
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.
Thank you so much for this demonstration. It worked PERFECTLY for what I needed. Again - Thank you so much!
Glad it helped!
I used it for a slightly different purpouse, but what you explained helped me effectively. Thanks man!
Glad it helped!
Thanks!
One million Thanks after struggling for weeks found home in your soln... Pranam...Thank you chandoo!!
Always welcome
This is really helpful. Can you also explain how 1 value can be displayed as a ratio of the other.
Very helpful as always! Thank you, Sir!🙏
Good one. Thanks
Awesome!! Exactly what I was looking for. 🤜🏾🤛🏾
Thank you!!!
It worked!! Thanks for explanation.
awesome tip worked perfectly thanks
What if I want to divide by Grand Total's value, how do I return that value into formula?
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?
Thank you so much 🙏🏻🙏🏻
You are welcome Melissa... :)
Very useful! Thanks a lot :-)
Hi, Thanks for the video, getting range & table instead of data in power pivot, to add additionally formula
please help, Thanks in advance
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
Chandoo it’s really helpful. But DAX formula looks too complicated.
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.
Hi if I want to find YOY and MOM how do I do so?
How to do the % calculation on month on month, can you show that in video
very helpful, thank you for sharing!
Glad it was helpful!
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?
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 ?
Gr8!
Hi please assist
How to subtract sales total from purchase total?
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!
Sure... Can you email me sample data at chandoo.d@gmail.com?
Did you get your reply? I have a similar issue
@@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! :(