{"id":4432,"date":"2016-02-08T18:51:39","date_gmt":"2016-02-08T17:51:39","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=4432"},"modified":"2020-09-04T09:37:47","modified_gmt":"2020-09-04T07:37:47","slug":"46-videonavod-jak-na-kontingencky-vlastni-vypocty","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/46-videonavod-jak-na-kontingencky-vlastni-vypocty\/","title":{"rendered":"46. Videotutorial &#8211; Deal with Pivot Tables 6 &#8211; Calculated field"},"content":{"rendered":"<p><\/p>\n<p style=\"text-align: justify;\">Another episode of tutorials\u00a0<a href=\"https:\/\/www.itlektor.cz\/en\/pivot-tables\/\">Deal with Pivot Tables<\/a>\u00a0continues with the topic\u00a0<strong>Calculated field<\/strong>. Without changing the source table we\u00a0will create a new column with a formula. You will learn how a field is added to the table, or to influence the source data and then update the PivotTable. If 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\/DaQmQb4jWTM?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;\">If you are for some time using Pivot Tables whose basics we have seen in previous episodes, you may have identified the need to create new calculations. I mean you need new columns from the existing columns to calculate the new value. Such a column we call calculated field and now I will show you how to do it.<\/p>\n<p style=\"text-align: justify;\">We see a Pivot Table with the travel cost to individual countries. We wish to express values \u200b\u200bin Euros. I do not want to change the source data, and writing a formula to neighboring cells (outside the pivot table) is possible, but ineffective in terms of future adjustments. Therefore, use the built-in tool for this purpose, go to Analysis tab, activate the button Fields, items and sets, Calculated field. You can create an entirely new column with a formula. We&#8217;ll call it &#8220;EURO&#8221; and into the formula enter the existing amount field (\u010c\u00e1stka) and divide by exchange rate for the Euro. Unfortunately we can not use the functions or links to cells. Click OK to confirm and field appears in a PivotTable. If it did not automatically, drag it to the Values \u200b\u200bsection. Remember to change the desired format. Thus calculated field can only display totals, other functions are unavailable.<\/p>\n<p style=\"text-align: justify;\">If we want to remove a calculated field, we need to find it again in the same way as when creating it. Here, then delete it.<\/p>\n<p style=\"text-align: justify;\">If something does not work, you still have the option to add new column with a formula into source table and then update the PivotTable.<\/p>\n<p style=\"text-align: justify;\">Next time we will look at filtering and Slicers, until then try introduced functionality and any questions should be directed video below.<\/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>Another episode of tutorials\u00a0Deal with Pivot Tables\u00a0continues with the topic\u00a0Calculated field. Without changing the source table we\u00a0will create a new column with a formula. You will learn how a field is added to the table, or to influence the source data and then update the PivotTable. If this guide has helped you, become a fan [&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":4433,"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\/4432"}],"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=4432"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/4432\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/4433"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=4432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=4432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=4432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}