Calculate MOM Month on Month (or YOY) growth - Pivot Table - No Formula - all Excel vers #shorts

preview_player
Показать описание
Calculate Month-on-month, Year-on-year or period-by-period growth / decline without formulas in Pivot Tables.
Show Values As - % Difference from - Previous.
Three clicks - Job done.

Download the sample file to try.
In the sample file, Amount column is added to the Data (Values) area twice. This is done to make it easier for you to interpret the results. In practice, the column is required only once.

Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------

Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------

Learn more from 1000+ blog articles by Dr Nitin Paranjape

Production
--------------------
Рекомендации по теме
Комментарии
Автор

thank you sir, just right what i need 🔥

hartonosusilo
Автор

Hi, thanks. Is there a way this could be done in Google Sheets?

richardborde
Автор

how to sort if i have sale qty and Amnt under month from Jan to Dec... Pivot is not making it easy..can you help me

WordsUnkown
Автор

Sir master office 365 course (₹ 1, 000)
Ish mahi koun kounse office software sikhaoge aap) sir.
Kindly reply 🙏

som-yf