LayoutofPivotTable
y RowArea– datadisplaysvertically,oneuniqueitemperro w .Youcanhave
nestedrows.TypesofdatayouwoulddropintheRowareaincludethosethat
youwantto groupandcategorize–forexample,Gender,Race,Location…..
y ColumnArea– datadisplayshorizontally,Thefieldsyouwanttodisplayas
columnsatthetopofthePivotTable.Oneuniquevaluepercolumn.Youcan
havenestedcolumns.Thetypesofdatayouwoulddrophereincludethoseyou
wantto trendorshowsidebyside–forexample,Month,Periods,Years….
y ReportFilt erArea–Afieldusedto filterthereport by selectingoneormore
items,enablingyouto displayasubsetofdata.Thetypesofdatayouwould
drophereincludethosethatyouwant toisolateandfocuson–forexample,
Employee’s,Classification,Regions…..
y ValuesArea–Thisisthecalculationarea,wherenumericaldataisshownand
summarized.Theitemsyouwoulddropherearethosethatyouwantto
measureorcalculate.Youcoulddropafieldinthevalueareamorethanonce,
butwithdifferentcalculations.Youmightneedminimum,maximum,meanof
salaries…..