{"id":4296,"date":"2015-10-24T14:26:11","date_gmt":"2015-10-24T12:26:11","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=4296"},"modified":"2020-09-04T09:39:10","modified_gmt":"2020-09-04T07:39:10","slug":"42-videonavod-jak-na-kontingencky-moznosti-vypoctu","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/42-videonavod-jak-na-kontingencky-moznosti-vypoctu\/","title":{"rendered":"42. Videotutorial &#8211; Deal with Pivot Tables 2 &#8211; Calculation options"},"content":{"rendered":"<p><\/p>\n<p style=\"text-align: justify;\">The video series\u00a0<a href=\"https:\/\/www.itlektor.cz\/en\/pivot-tables\/\">Deal with Pivot Tables<\/a>\u00a0continues with episode\u00a0<strong>Calculation options<\/strong>. In this tutorial you will learn how to change the aggregate function in calculations, how to set up percentage totals and how to display more summaries at once.\u00a0If this guide has helped you, become a fan on <a href=\"http:\/\/www.facebook.com\/itlektorcz\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n<p style=\"text-align: justify;\"><em>Please note that this tutorial is presented in czech language, with english subtitles.<\/em><\/p>\n<div class=\"potter-video\"><iframe width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/_80krMZpaog?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<p>Source file can be downloaded\u00a0<a href=\"https:\/\/www.itlektor.cz\/soubory\/kontingencky\/cesty.xlsx\">here<\/a>.<\/p>\n<p style=\"text-align: justify;\">We can see prepared Pivot table from the previous episode, showing the total summary cost of business trips in the country. Let&#8217;s look at the various options for calculations.<\/p>\n<p style=\"text-align: justify;\">The basic function is summary. If we want to change the type of subtotal function, just click in a field with right mouse and find a choice of Summarize Values by, where you select the desired function, e.g. average. Now we see the average cost of one business trip to each country. Nothing prevents us from seeing more calculations simultaneously. Dragging the cost (\u010c\u00e1stka) field again to the values section \u200b\u200band subsequent change in aggregate function in this column achieve a combination of both results, e.g. average and count.<\/p>\n<p style=\"text-align: justify;\">Drag the cost (\u010c\u00e1stka) field into Values sections \u200b\u200bfor the third time, but this time I change the calculation so that instead of numbers it shows the percentages of the total. It can be set again using the right mouse menu, find Show Values \u200b\u200bAs and choose % of Column Total, this option is one of the most widely used. The total of column Excel understood as 100%, and each value given to it expressed as a proportion.<\/p>\n<p style=\"text-align: justify;\">This is a general principle of making changes in the basic calculations in pivot tables.<\/p>\n<p style=\"text-align: justify;\">In the next episode we examine the Design tab, which contains not only arrangement options.<\/p>\n<p><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>The video series\u00a0Deal with Pivot Tables\u00a0continues with episode\u00a0Calculation options. In this tutorial you will learn how to change the aggregate function in calculations, how to set up percentage totals and how to display more summaries at once.\u00a0If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it\u00a0can [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":4297,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3,56],"tags":[10,70,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/4296"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=4296"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/4296\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/4297"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=4296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=4296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=4296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}