{"id":747,"date":"2023-06-19T10:48:53","date_gmt":"2023-06-19T02:48:53","guid":{"rendered":"https:\/\/www.info-trek.com\/blog\/?p=747"},"modified":"2024-05-02T12:11:04","modified_gmt":"2024-05-02T04:11:04","slug":"power-user-vs-top-feature-in-pivot-table-part-3","status":"publish","type":"post","link":"https:\/\/www.info-trek.com\/blog\/power-user-vs-top-feature-in-pivot-table-part-3\/","title":{"rendered":"Power User vs Top feature in Pivot Table \u2013 Part 3"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Sorting and Filtering Pivot Report<\/h3>\n\n\n\n<p>Sort and filter button will automatically add into your Pivot Table once you start creating it. It is part of the feature in Pivot Table. The sorting feature confuses a lot of my student, many times. The first thing that confuses them what should they do first while sorting? I totally understand this. Simply because if you take a good look at the structure of the Pivot Table, as you add many more fields into the report, all you get it one Filter button for Row fields and another one for Column fields.<\/p>\n\n\n\n<p>I will start real slow, so at the end of this section you have got to be confuse no more! I will be using the Pivot report as shown below as the example for this section.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.png\" alt=\"\" class=\"wp-image-6370\"\/><\/figure>\n\n\n\n<p>a) If you\u2019re going to sort the Category, you must have you\u2019re your cursor being placed at least on one of the Category Item, then sort (A-Z) or (Z-A).<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.1-1024x729.gif\" alt=\"\" class=\"wp-image-6371\"\/><\/figure>\n\n\n\n<p>If you are going to sort by the Product Name, then you will have to place your cursor at least at one of the items, then start sorting.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.2-1024x729.gif\" alt=\"\" class=\"wp-image-6372\"\/><\/figure>\n\n\n\n<p>If you\u2019re going to sort the number, please understand that the sorting goes by either the&nbsp; \u201cCategory\u201d or by the \u201cProduct Name\u201d. If is is by the \u201cCategory\u201d, which means the whole group of the Category will being sorted. This is how it looks like:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.3-1024x729.gif\" alt=\"\" class=\"wp-image-6373\"\/><\/figure>\n\n\n\n<p>If you\u2019re planning on sorting the values by the \u201cProduct Name\u201d, this is only happening within the \u201cCategory\u201d. Confuse? Check out the GIF below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.4-1024x729.gif\" alt=\"\" class=\"wp-image-6374\"\/><\/figure>\n\n\n\n<p>Now you understand what I\u2019m trying to say?<\/p>\n\n\n\n<p>b) To do the filter, this is a lil tricky. Especially while you\u2019re having multiple field being stacked together, that tends to get people a little confuse too. Now, if you want to filter by the name or item, what I usually called the label, you need to make sure when you look for the filter setting, look into the label section.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.5-1024x824.gif\" alt=\"\" class=\"wp-image-6375\"\/><\/figure>\n\n\n\n<p>To sort the by the \u201cCategory\u201d, you must first make sure the filtering setting is being set to sort by the \u201cCategory\u201d. Sames goes while you\u2019re sorting by the \u201cProduct Name\u201d, change the setting to \u201cProduct Name\u201d. This is how you\u2019re going to do it:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.6-1024x824.gif\" alt=\"\" class=\"wp-image-6376\"\/><\/figure>\n\n\n\n<p>After you select from the dropdown, you can then proceed to filter the label.<br>If you\u2019re planning to filter the Value, you will have to make sure you have selected the field from the dropdown before you start<\/p>\n\n\n\n<p>Let\u2019s talk about the TOP 10 filtering feature. I\u2019m going to change the sample of data for this example. The report will be as shown as the below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.7.png\" alt=\"\" class=\"wp-image-6377\"\/><\/figure>\n\n\n\n<p>Let\u2019s find the&nbsp;<strong>TOP 3 Product that generate the most sales<\/strong>.<br>With this setting :<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.8.png\" alt=\"\" class=\"wp-image-6378\"\/><\/figure>\n\n\n\n<p>This is what you\u2019re going to get, the top 3 product that generate highest sales.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.9-1024x824.gif\" alt=\"\" class=\"wp-image-6379\"\/><\/figure>\n\n\n\n<p>Now let\u2019s try the total sales generate by the items that sums up close to the amount (It will try to get as close to the number specified by you) that you stated in the value placeholder, you can either try TOP or BOTTOM. Top means the result will return by summing all the top values whereas BOTTOM will return the result by summing all the bottom numbers. Let\u2019s check out the GIF below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.10-1024x824.gif\" alt=\"\" class=\"wp-image-6380\"\/><\/figure>\n\n\n\n<p>One lat one, Sums by the Percent.<br>I\u2019m making an example of&nbsp;<strong>Bottom | 20% | Percent| Sum of Sales<\/strong><br>The sum of the sales of the bottom values that make up close to 20% of Grand Total.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.11-1024x824.gif\" alt=\"\" class=\"wp-image-6381\"\/><\/figure>\n\n\n\n<p>The other example I\u2019m making is TOP| 50%| Percent| Sum of Sales<br>The sum of the sales of the Top values that make up close to 50% of Grand Total<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.info-trek.com\/blog\/wp-content\/uploads\/2019\/09\/P3.12-1024x824.gif\" alt=\"\" class=\"wp-image-6382\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Sorting and Filtering Pivot Report Sort and filter button will automatically add into your Pivot Table once you start creating it. It is part of the feature in Pivot Table. The sorting feature confuses a lot of my student, many times. The first thing that confuses them what should they do first while sorting? I [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":749,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-747","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.info-trek.com\/blog\/wp-json\/wp\/v2\/posts\/747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.info-trek.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.info-trek.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.info-trek.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.info-trek.com\/blog\/wp-json\/wp\/v2\/comments?post=747"}],"version-history":[{"count":1,"href":"https:\/\/www.info-trek.com\/blog\/wp-json\/wp\/v2\/posts\/747\/revisions"}],"predecessor-version":[{"id":748,"href":"https:\/\/www.info-trek.com\/blog\/wp-json\/wp\/v2\/posts\/747\/revisions\/748"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.info-trek.com\/blog\/wp-json\/wp\/v2\/media\/749"}],"wp:attachment":[{"href":"https:\/\/www.info-trek.com\/blog\/wp-json\/wp\/v2\/media?parent=747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.info-trek.com\/blog\/wp-json\/wp\/v2\/categories?post=747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.info-trek.com\/blog\/wp-json\/wp\/v2\/tags?post=747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}