Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets

This feature is mostly helpful to publish the data in sheet wise

Step 1: Create pivot table with Report filter, go to analysis tab or Options tab from "PivotTable options"

Step 2: Click on options drop down
Step 3: Then click on “Show report filter pages”

Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.