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

Video duration: 2:23
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).

## 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: