Excel Magic Trick 1066: PivotTable: Month Over Month Sales Calculations From Transactional Data Set




About this tutorial:

Video duration: 2:23
Download Excel File:
See MOM calculations:
1. (00:18 min) Use PivotTable to calculate Month Over Month Sales Calculations From Transactional Data Set
2. (00:50 min) PivotTable to group by month
3. (00:50 min) PivotTable to add month sales
4. (01:11 min) Show in Tabular Format
5. (01:18 min) Number Formatting, Not Format Cells
6. (01:36 min) PivotTable to Calculate Percentage Change for each month (% Difference From Calculations: Show Values As Calculation).

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

9 thoughts on “Excel Magic Trick 1066: PivotTable: Month Over Month Sales Calculations From Transactional Data Set

    Ailin Fabian Varasteh

    (September 24, 2018 - 10:16 am)

    For some reason I cannot group the dates. What can I do? I checked for empty cells and I changed the formatting already.

    SIKKHAPARIYATTI DHAMMA

    (September 24, 2018 - 10:16 am)

    Thank you so much!. You show me how to do it too easily and save my time a lot!

    Elaine Lee

    (September 24, 2018 - 10:16 am)

    Outstanding instructions!

    Aaron Toys

    (September 24, 2018 - 10:16 am)

    Hi, great video. I'm having a small problem and I can't seem to find an answer anywhere. I have grouped my data by months and years (like you have) and I have several years worth of data. The problem that I have is that there is no result (the cell is blank) for the Jan cell, i.e. no comparison is being made between Dec-2014 and Jan-2015. Is there anyway to get Excel to compare the month over month figures for Jan & Dec? Thanks!

    Blaine Evans

    (September 24, 2018 - 10:16 am)

    Outstanding! Thank you!

    ExcelVbaIsFun

    (September 24, 2018 - 10:16 am)

    Thank you Excelisfun!

    Excel On Fire

    (September 24, 2018 - 10:16 am)

    YES YES YES!!!! Beautiful.

    Exploring Excel

    (September 24, 2018 - 10:16 am)

    Thanks for the video
    But i think formula method is good as it constantly updates the result if we alter any data. for pivot table we have to always press Refresh Links

    ExcelIsFun

    (September 24, 2018 - 10:16 am)

    Excel Magic Trick 1066: PivotTable: Month Over Month Sales Calculations From Transactional Data Set:

Leave a Reply

Your email address will not be published. Required fields are marked *