Summarize Sales Data by Year or Month or Quarter using Pivot Table Analyze

#microsoftexcel #pivottable

In this video, you will learn to generate month wise or year wise or quarter wise sales reports.

[PritamPaul]

Thanks a lot for this valuable information

[moesadr]

Great video, thank you. How about creating a dynamic report showing the totals in this format: This Month, Last Month and this quarter, last quarter and this year, last year at all times without any extra steps. something like a dashboard which always only automatically calculates and shows above mentioned values?

[farhanhashwani]

How to change calendar year monthwise data to financial year monthwise I.e. from July to June instead of Jan to December

[ajaynirmal]

But in india our financial year start from April to March so how to do this ??