Excel Pivot Table: How to Use Field as Filter And Row

Описание: In this tutorial, you’ll learn how to use a field both as a filter and as a row in your Excel Pivot Table. Follow these steps to effectively use a Field as Filter:

Select Your Pivot Table: Click on the Pivot Table that you want to configure.

Create Slicer: Go to the PivotTable Analyze tab and click on the "Insert Slicer" option. Next, select the field that you want to use as a filter.

Apply a Filter: Use the slicer to filter your data. You can also make multiple selections for more refined filtering.

Don’t forget to like, subscribe, and hit the bell icon for more helpful Excel tips and tutorials!

#ExcelTips #PivotTable #FilterAndRow #DataAnalysis #ExcelTutorial

Timestamps:

00:00 Intro
00:18 Use Field as Filter
00:48 Conclusion

🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions:    • 💰 Compound interest calculator template in...  
🎥 Common errors:    • 🚨 How to solve the #DIV/0! error in Excel  
🎥 How to tutorials:    • How to use UPPER in Excel  
🎥 Regular functions explained:    • BASIC EXCEL FUNCTIONS