{"id":4369,"date":"2015-12-15T18:40:52","date_gmt":"2015-12-15T17:40:52","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=4369"},"modified":"2020-09-04T09:38:49","modified_gmt":"2020-09-04T07:38:49","slug":"45-videonavod-jak-na-kontingencky-seskupovani-hodnot","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/45-videonavod-jak-na-kontingencky-seskupovani-hodnot\/","title":{"rendered":"45. Videotutorial &#8211; Deal with Pivot Tables 5 &#8211; Grouping"},"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>Grouping<\/strong> of dates of intervals. You can simply view the summary according to time of year, for example total for each month or quarter. Also you can see the value in increments of thousands or in other units. 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\/0YD5-YPX-Uk?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>From the previous parts you already know how to create and set up a basic Pivot table. The topic \u201cGrouping of values\u201d, which in this tutorial we will show, requires a properly selected data, and therefore we create entirely new Pivot table. We will use again spreadsheet of travels. Just to remind, you create new Pivot table so that we stand in the source table, select the Insert tab, click PivotTable, check the settings and select OK.<\/p>\n<p>The first grouping options we try is about dates. Drag the Date (Datum platby) field to the Rows section, and the Cost (\u010c\u00e1stka) field to the Values \u200b\u200bsection. The resulting summary shows the total cost of travel by day. But it would be much better to add up the sum in months or years. And the fact is Pivot table possibility of a simple grouping. Just right mouse click on Dates and choose Group. Because Excel recognizes that this is the date vale, it offers possibilities for meaningful summary of periods. You can also select multiple options, we try Years and Months. Once you confirm your settings, Pivot table simply calculates the overall totals.<\/p>\n<p>I return back Pivot table to the default blank format and try a second option. This time, drag the Amount field into Rows and ID field to Values. We understand that Pivot tables shows the frequency of the individual costs. Such information does not yet have a general explanatory value. But we can regroup Costs so that they are counted in the intervals by e.g. 20 000. Click the right mouse on Cost and choose Group. Excel will understand what we are going to do and offer formation intervals. You can set the initial and final value and incremental change. Let&#8217;s set the limits of 0 to 100 thousand incremental change is 20 000. After confirming we will see the result.<\/p>\n<p>Other tricks for grouping I like to teach you on my training. The next time you can enjoy the demo to create custom calculations in Pivot table, without having to change the source data.<\/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\u00a0Grouping of dates of intervals. You can simply view the summary according to time of year, for example total for each month or quarter. Also you can see the value in increments of thousands or in other units. If this guide has helped you, become a [&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":4370,"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\/4369"}],"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=4369"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/4369\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/4370"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=4369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=4369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=4369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}