Get a month of TabletWise Pro for free! Click here to redeem

0606 Filter - Choosing the Dataset Correctly

1 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$201.46
You save:  A$57.56
List Price:  ৳11,880.65
You save:  ৳3,394.71
List Price:  CA$190.27
You save:  CA$54.36
CHF 94.09
List Price:  CHF 131.73
You save:  CHF 37.64
List Price:  kr922.14
You save:  kr263.48
List Price:  €123.82
You save:  €35.37
List Price:  £110.81
You save:  £31.66
List Price:  HK$1,085.07
You save:  HK$310.04
List Price:  ₹10,524.04
You save:  ₹3,007.08
List Price:  RM597.26
You save:  RM170.66
List Price:  ₦54,219.52
You save:  ₦15,492.40
List Price:  kr1,320.98
You save:  kr377.45
List Price:  NZ$212.97
You save:  NZ$60.85
List Price:  ₱6,921.33
You save:  ₱1,977.66
List Price:  ₨23,247.81
You save:  ₨6,642.70
List Price:  S$194.74
You save:  S$55.64
List Price:  ฿4,384.27
You save:  ฿1,252.74
List Price:  ₺961.22
You save:  ₺274.65
List Price:  R2,346.24
You save:  R670.40
Already have an account? Log In


Hello. Today we will talk about what not to do while working with philtrum. Although there are many more things but I'll start with one major technique because I see professionals making that mistake quite often. And let me take this example which is there in the case studies that have been given. So we have couple of client lists all hypothetical data. Now, I've seen people that they simply choose the header and they go on to apply data and then filter.

Now this could be dangerous, why So assume that towards the middle or towards the end of the data, there may be a certain blank row entire who is blank. If you choose only the header and go to data and then apply filter, notice the filter button and the filter engine has not taken into account all the names below this blank cell. For testing purpose. If I click on the city drop down, I get only good girl and Kolkata. There is no option for Bombay in the drop down. So See, this could lead to erroneous results.

So my point is, anytime you wish to apply for it up, do not simply select the header. instead choose the entire block of data. So I'm going to use the same shortcut technique, dollar shift control right and down and then I will proceed with data and filter. So there you go. This is something what not to do before applying filter

Sign Up