1002 Pivot Table - Pre-requisites

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.21
You save:  د.إ146.92
List Price:  A$189.27
You save:  A$54.08
List Price:  ৳11,874.45
You save:  ৳3,392.94
List Price:  CA$174.19
You save:  CA$49.77
CHF 90.63
List Price:  CHF 126.88
You save:  CHF 36.25
List Price:  kr876.09
You save:  kr250.33
List Price:  €117.79
You save:  €33.65
List Price:  £100.24
You save:  £28.64
List Price:  HK$1,087.91
You save:  HK$310.85
List Price:  ₹10,396.08
You save:  ₹2,970.52
List Price:  RM592.78
You save:  RM169.38
List Price:  ₦57,615.03
You save:  ₦16,462.61
List Price:  kr1,223.76
You save:  kr349.67
List Price:  NZ$199.75
You save:  NZ$57.07
List Price:  ₱7,023.18
You save:  ₱2,006.76
List Price:  ₨22,717.01
You save:  ₨6,491.03
List Price:  S$189.41
You save:  S$54.12
List Price:  ฿4,598.67
You save:  ฿1,314
List Price:  ₺1,183.81
You save:  ₺338.25
List Price:  B$707.83
You save:  B$202.25
List Price:  R2,037.17
You save:  R582.09
List Price:  Лв230.32
You save:  Лв65.81
List Price:  ₩160,005.91
You save:  ₩45,719.24
List Price:  ₪453.71
You save:  ₪129.64
Already have an account? Log In


Hello, everyone, before I start speaking about pivot table and its various features, and the way to achieve them, I must make you aware about the prerequisites of pivot table. Well, the data that you're going to work with, you cannot just pick up any data and apply pivot table. And I've given some very basic examples to show you the differentiating factor between the data that you should be taking versus the data you cannot work with. Right now, I have a very simple data on the top left corner of my screen, which talks about chocolate ice cream, and in two years, what has been the sales amount? Well, this is not one dimensional data, this is not a columnar data, this actually based on two dimensions of variables. If you want to work with pivot table, you have to have columnar data or in other words, one dimensional data, which means you would have data which says chocolate 2008, and then the sales hundred so each one line item is an independent line item.

So if you have a data which looks like this You have got to convert this into this form before you apply pivot table and this pivot table which you apply based on the table number two is going to give you a lot many more flexible features which you can apply and make use of. Secondly, you must not have any header which is left blank. For example, if you keep this header blank, which may or may not be hidden, and if you go ahead and try to make a pivot table, eventually it stops you It gives an error message saying that this is not allowed you cannot have a header which is blank. The third point you cannot have a data which has more Excel for example, I have particularly ensured that this table number two, the header has a merged cell. And if I try to choose the entire block of data, notice the extra cell which is not merged also gets chosen.

So if I go ahead and say insert and pivot table, okay, yeah, same error. Why? Because this extra cells that got chosen is not having Any header. So, in simple words the three points that you need to take care of before you start preparing pivot table one it should be in columnar form. Secondly, it should have an header which is given with certain text or number but should not be left blank and third there should be no merge cell. So, once this prerequisites have been maintained, then we talked about pivot table.

See you in the next video.

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.