You can view and interact with PivotTables in Excel Online, which includes some manual filtering and using slicers that were created in the Excel desktop application to filter your data. You won’t be able to create new slicers in Excel Online.
To filter your PivotTable data, do one of the following:
To apply a manual filter, click the arrow on Row Labels or Column Labels, and then pick the filtering options you want.
If your PivotTable has slicers, just click the items you want to show in each slicer.
If you have the Excel desktop application, you can use the Open in Excel button to open the workbook and apply additional filters or create new slicers for your PivotTable data there. Here’s how:
Click Open in Excel and filter your data in the PivotTable.
For news about the latest Excel Online updates, visit the Microsoft Excel blog.