How to create monthly summary of sales

I have sales data, now I’ll show you how we can create a monthly summary from it

I have the data below, please take a look.

Create a new column.

To extract the month from the date

And apply the TEXT formula.

Drag The formula

And This interface Has Come

Insert Pivot Table on This Data

Select All The data And Goto Pivot Table

Then Select Fro Table/Range

 In the Pivot Table Field List:

  • Drag “Months” into the Rows area
  • Drag “Sales” into the Values area

  Make sure it’s summarizing by Sum (which it does by default)

That’s It Ready Your Sale Summary

Thank You

Leave a Reply

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