Multiple fields in row, column or data section

Basic Microsoft Excel Course Introduction to Pivot chart and tables
2 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€92.26
List Price:  €129.17
You save:  €36.90
£78.58
List Price:  £110.02
You save:  £31.43
CA$136.53
List Price:  CA$191.15
You save:  CA$54.61
A$150.05
List Price:  A$210.08
You save:  A$60.02
S$134.83
List Price:  S$188.77
You save:  S$53.93
HK$780.51
List Price:  HK$1,092.75
You save:  HK$312.23
CHF 91.40
List Price:  CHF 127.97
You save:  CHF 36.56
NOK kr1,068.48
List Price:  NOK kr1,495.92
You save:  NOK kr427.43
DKK kr688.44
List Price:  DKK kr963.84
You save:  DKK kr275.40
NZ$163.35
List Price:  NZ$228.70
You save:  NZ$65.35
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.92
৳11,721.12
List Price:  ৳16,410.04
You save:  ৳4,688.92
₹8,326.41
List Price:  ₹11,657.31
You save:  ₹3,330.90
RM469.20
List Price:  RM656.90
You save:  RM187.70
₦143,785.62
List Price:  ₦201,305.62
You save:  ₦57,520
₨27,847.71
List Price:  ₨38,987.91
You save:  ₨11,140.19
฿3,633.91
List Price:  ฿5,087.62
You save:  ฿1,453.71
₺3,217.97
List Price:  ₺4,505.29
You save:  ₺1,287.32
B$512.23
List Price:  B$717.15
You save:  B$204.91
R1,817.89
List Price:  R2,545.11
You save:  R727.22
Лв180.27
List Price:  Лв252.39
You save:  Лв72.11
₩136,618.14
List Price:  ₩191,270.87
You save:  ₩54,652.72
₪367.26
List Price:  ₪514.18
You save:  ₪146.92
₱5,803.01
List Price:  ₱8,124.45
You save:  ₱2,321.43
¥15,641.03
List Price:  ¥21,898.07
You save:  ¥6,257.04
MX$1,661.48
List Price:  MX$2,326.14
You save:  MX$664.66
QR364.73
List Price:  QR510.64
You save:  QR145.90
P1,348.30
List Price:  P1,887.68
You save:  P539.37
KSh13,198.68
List Price:  KSh18,478.68
You save:  KSh5,280
E£4,678.53
List Price:  E£6,550.13
You save:  E£1,871.60
ብር5,747.26
List Price:  ብር8,046.40
You save:  ብር2,299.13
Kz85,041.49
List Price:  Kz119,061.49
You save:  Kz34,020
CLP$88,840.11
List Price:  CLP$124,379.71
You save:  CLP$35,539.60
CN¥709.27
List Price:  CN¥993.01
You save:  CN¥283.74
RD$5,874.72
List Price:  RD$8,224.84
You save:  RD$2,350.12
DA13,454.48
List Price:  DA18,836.81
You save:  DA5,382.33
FJ$226.07
List Price:  FJ$316.51
You save:  FJ$90.44
Q776.68
List Price:  Q1,087.38
You save:  Q310.70
GY$20,942.51
List Price:  GY$29,320.35
You save:  GY$8,377.84
ISK kr13,848.61
List Price:  ISK kr19,388.61
You save:  ISK kr5,540
DH992.77
List Price:  DH1,389.92
You save:  DH397.15
L1,766.77
List Price:  L2,473.55
You save:  L706.77
ден5,684.23
List Price:  ден7,958.15
You save:  ден2,273.92
MOP$804.15
List Price:  MOP$1,125.85
You save:  MOP$321.69
N$1,813.62
List Price:  N$2,539.14
You save:  N$725.52
C$3,682.63
List Price:  C$5,155.83
You save:  C$1,473.20
रु13,330.40
List Price:  रु18,663.10
You save:  रु5,332.69
S/374.77
List Price:  S/524.70
You save:  S/149.92
K388.70
List Price:  K544.20
You save:  K155.49
SAR375.01
List Price:  SAR525.03
You save:  SAR150.02
ZK2,583.64
List Price:  ZK3,617.21
You save:  ZK1,033.56
L459.02
List Price:  L642.65
You save:  L183.62
Kč2,281.25
List Price:  Kč3,193.84
You save:  Kč912.59
Ft35,715.37
List Price:  Ft50,002.94
You save:  Ft14,287.57
SEK kr1,072.36
List Price:  SEK kr1,501.36
You save:  SEK kr428.99
ARS$88,916.93
List Price:  ARS$124,487.26
You save:  ARS$35,570.33
Bs691.33
List Price:  Bs967.89
You save:  Bs276.56
COP$382,975.61
List Price:  COP$536,181.17
You save:  COP$153,205.56
₡51,262.22
List Price:  ₡71,769.17
You save:  ₡20,506.94
L2,472.61
List Price:  L3,461.75
You save:  L989.14
₲751,156.78
List Price:  ₲1,051,649.55
You save:  ₲300,492.76
$U3,841.99
List Price:  $U5,378.94
You save:  $U1,536.95
zł393.60
List Price:  zł551.05
You save:  zł157.45
Already have an account? Log In

Transcript

Before beginning to select the fields for the pivot table, we need to understand what is our final goal that is, what do we want to analyze from this data? For our first example, let us try to find out how many months has each male and female employee served. That is, we want to find out the number of months served, and how many male employees have So, those many months and how many female employees have served those many months. For that, we would have to select the fields from this list. So, we will take the service period total months old in rows that is on the left hand side of the table gender in columns Because we want to find out how many female employees have served zero months mean employees have served zero months, and so on so forth for each of these. And now we'll take employee code because you want to find out how many of them are there in each of these years.

But when I directly select the employee code and drag it to some of value section in the pivot table, I can see that Excel has added that is summed all the employee codes, but I don't want that. I want Excel to give me a count. For that, I would click this arrow go to value field Settings, select count, and click on OK So now I have the output as follows. There are two female employees who have served one month. There are five male employees who have served leaven months of service and to female employees who have served 11 months of service.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.