Pivot Table- It is “Manager’s special tool ” , data can be summarized very quickly for data analysis or report output. ( Handle Large Data with – All Other Uses of Pivot Table )
- PIVOT TABLE – this can be used for multiple task, basic use for summarize the data.
- Basic Architecture – first it groups the data and provides the option to set on row level and column with value aggregate option , filters can be applied in report filter (Also click for Dynamic Pivot Table)
Field – all field will be displayed in this section
ROW label – Which field has to be grouped and will reflect on row label
COLUMN label – Which field has to be grouped and will reflect on column label
VALUE – Option to aggregate values on sum, count, average( Mean) , min, max, var, std etc.
- PIVOT TABLE – Table is showing each value on group (it will appear only once, because it has been grouped ) and number has been summed up (calculation type can be changed just right lick on table, option will be appeared).
- You can view in the raw data subject “English” is repeated many times.
REPORT filer – this option provides the flexibility to filter a report.
Example – “Grade” is selected in report filter, just click on filter and change the criteria, report will be changed basis on it. It is just like a criteria option to input for report.