TabletWise.com
 

Creating and using calculated fields

2 minutes
Share the link to this page
Copied
  Completed
You need to purchase the class to view this lesson.
One-time Purchase
$99.99
List Price:  $139.99
You save:  $40
د.إ367.25
List Price:  د.إ514.17
You save:  د.إ146.91
A$129.88
List Price:  A$181.84
You save:  A$51.96
৳8,480.46
List Price:  ৳11,872.99
You save:  ৳3,392.52
CA$127.31
List Price:  CA$178.23
You save:  CA$50.92
CHF 88.88
List Price:  CHF 124.44
You save:  CHF 35.55
kr613.66
List Price:  kr859.15
You save:  kr245.49
€82.48
List Price:  €115.48
You save:  €32.99
£73.38
List Price:  £102.74
You save:  £29.35
HK$775.14
List Price:  HK$1,085.24
You save:  HK$310.09
₹7,318.41
List Price:  ₹10,246.07
You save:  ₹2,927.65
RM404.95
List Price:  RM566.95
You save:  RM162
₦38,046.19
List Price:  ₦53,266.19
You save:  ₦15,220
kr853.56
List Price:  kr1,195.02
You save:  kr341.45
NZ$140.52
List Price:  NZ$196.73
You save:  NZ$56.21
₱4,805.95
List Price:  ₱6,728.52
You save:  ₱1,922.57
₨16,053.39
List Price:  ₨22,475.39
You save:  ₨6,422
S$132.91
List Price:  S$186.08
You save:  S$53.17
฿2,997.70
List Price:  ฿4,196.90
You save:  ฿1,199.20
₺746.78
List Price:  ₺1,045.53
You save:  ₺298.74
B$533.92
List Price:  B$747.52
You save:  B$213.59
R1,498.23
List Price:  R2,097.59
You save:  R599.35
Лв161.23
List Price:  Лв225.73
You save:  Лв64.50
₩110,198.94
List Price:  ₩154,282.92
You save:  ₩44,083.98
₪324.81
List Price:  ₪454.74
You save:  ₪129.93
Already have an account? Log In

Transcript

Let us take one more example that is go back to our data, select the entire data go to insert pivot table there are select OK. Now, the new pivot table has been created in sheet three. This time there is analyze, how many employees have resigned from each of the programs. So, our data should have the program names on the left hand side with the number of employees that have resigned in the following column. So, for that we will select the program names as rows and employee code as summation of values because only want the count of the employees. Again, we will change the field settings to count. As you can see, there are many other options over here like average maximum minimum product, and some which was selected by default.

We can use this based on our requirement. After clicking on Ok, I can see that from ABC program, there were 20 employees who had resigned from KLM program there were two employees who are designed. In this way, we can analyze the data from different perspectives and arrive at conclusions. Also, it is a good way to represent the data using charts. There are many options in Excel that we can use To represent the data

Sign Up

Share

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