MS Excel Lesson34 | how to generate multiple reports from one pivot table | Reporting Filter pages

Asslam_u_Alaikum!
Dear Students!
welcome to 34th lesson of MS Excel. in this lesson you will learn about how to generate multiple reports from one pivot table using Mouse and Short cut Commands.
In this video I show you how to generate multiple reports from one pivot table.
Creating a Pivot Table
1)Select any cell in the source data table.
2)On the Ribbon, click the Insert tab.
3)In the Tables group, click Recommended PivotTables.
4)In the Recommended PivotTables window, scroll down the list, to see the suggested layouts. ...
5)Click on the layout that you want to use, then click OK.

what is pivot table
1)A pivot table is a statistics tool that summarize and reorganize selected columns and rows of data in a spreadsheet or database table to obtain a desired report.
2)A Pivot Table lets you rotate the data summary and look it from different angles.
3)It allow user to change column into Row and Vice versa.
Important benefit of pivot tables is that it helps to summarize data in a quick and easy manner.

In the PivotTable, select a row field.

1)This displays the PivotTable Tools tab on the ribbon.
2)You can also double-click the row field in outline or tabular form, and continue with step 3.
3)On the Analyze or Options tab, in the Active Field group, click Field Settings.
4)In the Field Settings dialog box, click the Layout & Print tab, and then under Layout, do one of the following:
5)To show field items in outline form, click Show item labels in outline form.
6)To display or hide labels from the next field in the same column in compact form, click Show item labels in outline form, and then select Display labels from the next field in the same column (compact form).
7)To show field items in table-like form, click Show item labels in tabular form.

Like my Video and Subscribe my Channel. Have any Question comment in video.

Here is the link of practice file. watch video again and again and practice daily Because "Practice Makes Permanent"

#pivot
#pivot_table
#Reports

what is pivot table
what is a pivot table
what is pivot table in excel
pivot table excel advanced
introduction to pivot tables
pivot
excel pivot tables
pivot tables excel
excel pivot table
pivot tables
pivot table excel
pivot excel
sort in pivot table
custom sort pivot table
manual sort pivot table
pivot table filter column values
group in pivot table
report filter in pivot table
report filter in pivot
how do i add a filter to a pivot table
filter pivot table based on list
pivot table dependent filter
pivot table advanced filter
filtering reporting excel

[Tat-cxlr]

Thanks for this video. But when selecting "Show Report Filter Pages...:", the worksheets are created correctly for each person but the formatting is not totally preserved. Can you help me please. Merci