📈Create Pivot Table Report Filter Pages

Create MULTIPLE Pivot Tables in Excel to summarize data based on the field in the Filters area.

#excel #pivottables
In this lesson, we are analysing sales data for a pizza restaurant. My boss has asked me to create an analysis that shows the total sales by month for each pizza category: Supreme, Classic, Veggie and Chicken. The catch? He wants a new PivotTable created for each pizza category!

That sounds like a lot of work! I'll need to create 4 pizza tables on 4 separate worksheets.

Fortunately, my colleague Pam knows a great trick to do this in one-click! Watch the video to see Pam's solution.

********************************

🔗LINKS to related videos

📈Excel Pivot Tables in 15 Minutes
   • Excel Pivot Tables in 15 Minutes!  

📉Create a Basic Pivot Table in Excel - Part 1
   • 🎉Create a Basic Pivot Table in Excel ...  

📊Create a Basic Pivot Table in Excel - Part 2
   • 📈Basic Pivot Table Skills: Part 2✌🏻  

************************************************

🤝Let's CONNECT on social:

➡️TikTok:   / cellmates_  

➡️Instagram:   / cellmatestr.  .

➡️LinkedIn:   / deborahas.  .

➡️Twitter:   / cellmates_  

➡️Facebook:   / cellmates