{"id":6946,"date":"2024-08-13T14:44:16","date_gmt":"2024-08-13T11:44:16","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&p=6946"},"modified":"2024-08-13T14:58:32","modified_gmt":"2024-08-13T11:58:32","slug":"pravylo-pidsvitky-zverhu-znyzu","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/stvorennya-interaktyvnogo-deshborda\/pidsvitka\/pravylo-pidsvitky-zverhu-znyzu\/","title":{"rendered":"Format Rule: Top N \/ Bottom N"},"content":{"rendered":"

The \u201cTop-Bottom\u201d format conditions allow you to highlight a specific number of topmost\/bottommost values. You can specify this number as an absolute or percent value:<\/p>\n

\"\"<\/a><\/p>\n

For example, let us select 4 quarters for which the \u201cSales Amount\u201d measure values were the worst. Select the type of \u201cBottom N\u201d highlight and fill out the form as follows:<\/p>\n

\"\"<\/a><\/p>\n

Pivot will look like this:<\/p>\n

\"\"<\/a><\/p>\n

Now let us check those product categories, the profit from which amounted to 90% of the total profit. For this, select the \u201cTop N\u201d highlight type and fill out the form as follows:<\/p>\n

\"\"<\/a><\/p>\n

We get the following Pivot:<\/p>\n

\"\"<\/a><\/p>\n

Two product categories \u2013 \u201cBikes\u201d and \u201cComponents\u201d – gave 90% out of all profits.<\/p>","protected":false},"featured_media":0,"parent":6908,"menu_order":520,"template":"","manuals":[18],"class_list":["post-6946","manual","type-manual","status-publish","hentry","manuals-bat-desktop"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/6946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/6908"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=6946"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=6946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}