{"id":13450,"date":"2018-04-03T13:56:09","date_gmt":"2018-04-03T13:56:09","guid":{"rendered":"https:\/\/kb.sambapos.com\/?p=13450"},"modified":"2020-09-30T14:17:00","modified_gmt":"2020-09-30T14:17:00","slug":"9-4-how-to-create-item-group-sales-report-according-to-ticket-type","status":"publish","type":"post","link":"https:\/\/kb.sambapos.com\/en\/9-4-how-to-create-item-group-sales-report-according-to-ticket-type\/","title":{"rendered":"9.4. How to Create Item Group Sales Report According to Ticket Type?"},"content":{"rendered":"<p>In order to create item group sales report according to ticket type, go to <strong>Manage &gt; Reports &gt; Reports<\/strong> from here click on <strong>Add Report<\/strong> link.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13451 size-large\" src=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-4-How-to-Create-Item-Group-Sales-Report-According-to-Ticket-Type-01-1024x576.jpg\" alt=\"\" width=\"640\" height=\"360\" srcset=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-4-How-to-Create-Item-Group-Sales-Report-According-to-Ticket-Type-01-1024x576.jpg 1024w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-4-How-to-Create-Item-Group-Sales-Report-According-to-Ticket-Type-01-300x169.jpg 300w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-4-How-to-Create-Item-Group-Sales-Report-According-to-Ticket-Type-01-768x432.jpg 768w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-4-How-to-Create-Item-Group-Sales-Report-According-to-Ticket-Type-01.jpg 1366w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<ul>\n<li><strong>Name:<\/strong>\u00a0Field to write name of report. (For example; Item Group Sales Report &#8211; According to Ticket Type)<\/li>\n<li><strong>Page Size: <\/strong>Field to set page size. (In the example; 500px)<\/li>\n<li><strong>Display in Report Explorer:<\/strong>\u00a0Activate by selecting the box.<\/li>\n<li><strong>Template:<\/strong>\u00a0Copy the code below into template area.<\/li>\n<\/ul>\n<table style=\"width: 100%; border-collapse: collapse; border-color: #dedede; background-color: #dedede;\">\n<tbody>\n<tr>\n<td style=\"width: 100%;\"><code>@{TICKET TYPE LIST}<br \/>\n[Sales Based on Item Group - $1:2, 1, 1]<br \/>\n{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent.desc,O.ExactTotal.Sum:(ODI=True) and (TY=$1)}<br \/>\n&gt;Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) and (TY=$1)}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>After completing necessary editings, click on Save button. You can display related report on navigation screen in the Reports menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13453 size-large\" src=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-4-How-to-Create-Item-Group-Sales-Report-According-to-Ticket-Type-02-1024x576.jpg\" alt=\"\" width=\"640\" height=\"360\" srcset=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-4-How-to-Create-Item-Group-Sales-Report-According-to-Ticket-Type-02-1024x576.jpg 1024w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-4-How-to-Create-Item-Group-Sales-Report-According-to-Ticket-Type-02-300x169.jpg 300w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-4-How-to-Create-Item-Group-Sales-Report-According-to-Ticket-Type-02-768x432.jpg 768w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-4-How-to-Create-Item-Group-Sales-Report-According-to-Ticket-Type-02.jpg 1366w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In order to create item group sales report according to ticket type, go to Manage &gt; Reports &gt; Reports from here click on Add Report link. Name:\u00a0Field to write name of report. (For example; Item Group Sales Report &#8211; According to Ticket Type) Page Size: Field to set page size. (In the example; 500px) Display [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-13450","post","type-post","status-publish","format-standard","hentry","category-reports"],"_links":{"self":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/13450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/comments?post=13450"}],"version-history":[{"count":2,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/13450\/revisions"}],"predecessor-version":[{"id":25083,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/13450\/revisions\/25083"}],"wp:attachment":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/media?parent=13450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/categories?post=13450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/tags?post=13450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}