Pivot table field and regional
Screening line column values
How to change the PivotTable layout
Collect classified in total report layout
Pivot table refresh
Manually refresh the set all refresh automatically refresh
when open the fileImplement sectional statistic
Automatic equidistance combination custom combination
Change value summary according to the
Sum counting average maximum/minimum product
Set up three percentage value
Total percentage classification percentage
Task a 1.1 statis-tical each city college, bachelor, master, Dr. Hiring, to the degree does not require recruitment is not taken into account, rendering is as follows:
The first topic is to count, this line is set to the city, the column set to education, education with educational count so choice, results are as follows:
1.2 statis-tical each city college, bachelor, master, Dr. Average minimum wage, the education there is no requirement of recruitment is not taken into account, rendering is as follows:
Second priority pivot table operations, no difficulty, the results are as follows:
Used task two filter, statistical each city, different working years, different educational background, how much is the average of the minimum wage, the record of formal schooling and working life of no requirement is not taken into account, the effect is as follows:
Because of adding the filter column, here the city into the filter, the result is shown in figure:
