Multiple fields in row, column or data section

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.17
You save:  د.إ146.91
List Price:  A$180.71
You save:  A$51.63
List Price:  ৳11,865.26
You save:  ৳3,390.31
List Price:  CA$177.71
You save:  CA$50.78
CHF 88.67
List Price:  CHF 124.14
You save:  CHF 35.47
List Price:  kr856.17
You save:  kr244.63
List Price:  €115.08
You save:  €32.88
List Price:  £101.93
You save:  £29.12
List Price:  HK$1,085.25
You save:  HK$310.09
List Price:  ₹10,208.62
You save:  ₹2,916.95
List Price:  RM566.18
You save:  RM161.78
List Price:  ₦53,406.18
You save:  ₦15,260
List Price:  kr1,194.21
You save:  kr341.22
List Price:  NZ$193.35
You save:  NZ$55.24
List Price:  ₱6,727.21
You save:  ₱1,922.20
List Price:  ₨22,496.39
You save:  ₨6,428
List Price:  S$185.42
You save:  S$52.98
List Price:  ฿4,192.98
You save:  ฿1,198.08
List Price:  ₺1,028.26
You save:  ₺293.81
List Price:  B$748.10
You save:  B$213.76
List Price:  R2,111
You save:  R603.18
List Price:  Лв225.10
You save:  Лв64.32
List Price:  ₩154,442.06
You save:  ₩44,129.45
List Price:  ₪457.05
You save:  ₪130.59
Already have an account? Log In


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 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.