{"id":2811,"date":"2020-02-04T14:13:35","date_gmt":"2020-02-04T07:13:35","guid":{"rendered":"https:\/\/www.support.skybizglobal.com\/?p=2811"},"modified":"2020-02-04T16:11:58","modified_gmt":"2020-02-04T09:11:58","slug":"multi-dimensional-analysis-report-generate_excel","status":"publish","type":"post","link":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/","title":{"rendered":"Multi-Dimensional Analysis Report Generate Excel"},"content":{"rendered":"<h4><strong><span style=\"color: #3498db;\">Below are guideline(s) to Generate Multi-Dimensional Analysis Report:<\/span><\/strong><\/h4>\n<div id=\"attachment_2813\" style=\"width: 1587px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2813\" class=\"wp-image-2813 size-full\" src=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1.png\" alt=\"\" width=\"1577\" height=\"769\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1.png 1577w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1-300x146.png 300w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1-768x375.png 768w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1-1024x499.png 1024w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1-150x73.png 150w\" sizes=\"auto, (max-width: 1577px) 100vw, 1577px\" \/><\/a><p id=\"caption-attachment-2813\" class=\"wp-caption-text\">Multi-Dimensional Analysis<\/p><\/div>\n<p>1. Choose <strong>Multi-Dimensional Analysis<\/strong><\/p>\n<div id=\"attachment_2815\" style=\"width: 1587px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step2.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2815\" class=\"wp-image-2815 size-full\" src=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step2.png\" alt=\"\" width=\"1577\" height=\"703\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step2.png 1577w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step2-300x134.png 300w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step2-768x342.png 768w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step2-1024x456.png 1024w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step2-150x67.png 150w\" sizes=\"auto, (max-width: 1577px) 100vw, 1577px\" \/><\/a><p id=\"caption-attachment-2815\" class=\"wp-caption-text\">Choose Query<\/p><\/div>\n<p>2. Choose the right <strong>Query<\/strong><\/p>\n<div id=\"attachment_2816\" style=\"width: 1591px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step3.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2816\" class=\"wp-image-2816 size-full\" src=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step3.png\" alt=\"\" width=\"1581\" height=\"785\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step3.png 1581w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step3-300x149.png 300w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step3-768x381.png 768w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step3-1024x508.png 1024w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step3-150x74.png 150w\" sizes=\"auto, (max-width: 1581px) 100vw, 1581px\" \/><\/a><p id=\"caption-attachment-2816\" class=\"wp-caption-text\">Date &amp; Generate<\/p><\/div>\n<p>3. Select the <strong>Date<\/strong> and Choose <strong>Generate<\/strong><\/p>\n<div id=\"attachment_2817\" style=\"width: 1589px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step4.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2817\" class=\"wp-image-2817 size-full\" src=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step4.png\" alt=\"\" width=\"1579\" height=\"789\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step4.png 1579w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step4-300x150.png 300w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step4-768x384.png 768w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step4-1024x512.png 1024w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step4-150x75.png 150w\" sizes=\"auto, (max-width: 1579px) 100vw, 1579px\" \/><\/a><p id=\"caption-attachment-2817\" class=\"wp-caption-text\">Excel File<\/p><\/div>\n<p>4. Open the <strong>Excel File<\/strong><\/p>\n<p>&nbsp;<\/p>\n<div id=\"attachment_2819\" style=\"width: 1606px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step6.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2819\" class=\"wp-image-2819 size-full\" src=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step6.png\" alt=\"\" width=\"1596\" height=\"856\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step6.png 1596w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step6-300x161.png 300w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step6-768x412.png 768w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step6-1024x549.png 1024w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step6-150x80.png 150w\" sizes=\"auto, (max-width: 1596px) 100vw, 1596px\" \/><\/a><p id=\"caption-attachment-2819\" class=\"wp-caption-text\">Select Cell<\/p><\/div>\n<p>5.Select the <strong>Cells<\/strong>&gt;&gt;<strong>Insert<\/strong>&gt;&gt;<strong>PivotTable<\/strong><\/p>\n<div id=\"attachment_2820\" style=\"width: 1610px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step7.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2820\" class=\"wp-image-2820 size-full\" src=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step7.png\" alt=\"\" width=\"1600\" height=\"860\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step7.png 1600w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step7-300x161.png 300w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step7-768x413.png 768w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step7-1024x550.png 1024w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step7-150x81.png 150w\" sizes=\"auto, (max-width: 1600px) 100vw, 1600px\" \/><\/a><p id=\"caption-attachment-2820\" class=\"wp-caption-text\">PivotTable<\/p><\/div>\n<div id=\"attachment_2821\" style=\"width: 1606px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step8.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2821\" class=\"wp-image-2821 size-full\" src=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step8.png\" alt=\"\" width=\"1596\" height=\"858\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step8.png 1596w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step8-300x161.png 300w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step8-768x413.png 768w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step8-1024x550.png 1024w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step8-150x81.png 150w\" sizes=\"auto, (max-width: 1596px) 100vw, 1596px\" \/><\/a><p id=\"caption-attachment-2821\" class=\"wp-caption-text\">SalesPersonCode<\/p><\/div>\n<p>6.Click <strong>SalesPersonCode<\/strong> and <strong>Select Add Row Labels<\/strong><\/p>\n<div id=\"attachment_2822\" style=\"width: 1610px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step9.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2822\" class=\"wp-image-2822 size-full\" src=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step9.png\" alt=\"\" width=\"1600\" height=\"856\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step9.png 1600w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step9-300x161.png 300w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step9-768x411.png 768w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step9-1024x548.png 1024w, https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step9-150x80.png 150w\" sizes=\"auto, (max-width: 1600px) 100vw, 1600px\" \/><\/a><p id=\"caption-attachment-2822\" class=\"wp-caption-text\">hcnetamt<\/p><\/div>\n<p>7. Click <strong>hcnetamt<\/strong> and <strong>Add to Values<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Powered By<\/strong> : <a href=\"https:\/\/www.skybiz.my\/\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color: #3498db;\"><strong>SKYBIZ \u00ae \u00a0Beyond Cloud \u2122<\/strong><\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Below are guideline(s) to Generate Multi-Dimensional Analysis Report: 1. Choose Multi-Dimensional Analysis 2. Choose the right Query 3. Select the Date and Choose Generate 4. Open the Excel File &nbsp; 5.Select the Cells&gt;&gt;Insert&gt;&gt;PivotTable 6.Click SalesPersonCode and Select Add Row Labels 7. Click hcnetamt and Add to Values &nbsp; Powered By : SKYBIZ \u00ae \u00a0Beyond Cloud ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85,143,67],"tags":[150,149],"class_list":["post-2811","post","type-post","status-publish","format-standard","hentry","category-0109-sales-person","category-0902-multi-dimensional-analysis","category-cloudbackend","tag-generate","tag-salespersonreport"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Multi-Dimensional Analysis Report Generate Excel - SKYBIZ Cloud ERP Support<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Multi-Dimensional Analysis Report Generate Excel - SKYBIZ Cloud ERP Support\" \/>\n<meta property=\"og:description\" content=\"Below are guideline(s) to Generate Multi-Dimensional Analysis Report: 1. Choose Multi-Dimensional Analysis 2. Choose the right Query 3. Select the Date and Choose Generate 4. Open the Excel File &nbsp; 5.Select the Cells&gt;&gt;Insert&gt;&gt;PivotTable 6.Click SalesPersonCode and Select Add Row Labels 7. Click hcnetamt and Add to Values &nbsp; Powered By : SKYBIZ \u00ae \u00a0Beyond Cloud ..Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/\" \/>\n<meta property=\"og:site_name\" content=\"SKYBIZ Cloud ERP Support\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-04T07:13:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-04T09:11:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1577\" \/>\n\t<meta property=\"og:image:height\" content=\"769\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Technical 1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Technical 1\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/\"},\"author\":{\"name\":\"Technical 1\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/#\\\/schema\\\/person\\\/fbf8363b58da4cbb4f5387de1113725c\"},\"headline\":\"Multi-Dimensional Analysis Report Generate Excel\",\"datePublished\":\"2020-02-04T07:13:35+00:00\",\"dateModified\":\"2020-02-04T09:11:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/\"},\"wordCount\":130,\"image\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SalesPersonReportGenerate_Step1.png\",\"keywords\":[\"Generate\",\"SalesPersonReport\"],\"articleSection\":[\"0109.Sales Person\",\"0902. Multi-Dimensional Analysis\",\"Cloud@Backend\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/\",\"url\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/\",\"name\":\"Multi-Dimensional Analysis Report Generate Excel - SKYBIZ Cloud ERP Support\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SalesPersonReportGenerate_Step1.png\",\"datePublished\":\"2020-02-04T07:13:35+00:00\",\"dateModified\":\"2020-02-04T09:11:58+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/#\\\/schema\\\/person\\\/fbf8363b58da4cbb4f5387de1113725c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SalesPersonReportGenerate_Step1.png\",\"contentUrl\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SalesPersonReportGenerate_Step1.png\",\"width\":1577,\"height\":769},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/multi-dimensional-analysis-report-generate_excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Multi-Dimensional Analysis Report Generate Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/#website\",\"url\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/\",\"name\":\"SKYBIZ Cloud ERP Support\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/#\\\/schema\\\/person\\\/fbf8363b58da4cbb4f5387de1113725c\",\"name\":\"Technical 1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g\",\"caption\":\"Technical 1\"},\"url\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/author\\\/technical1\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Multi-Dimensional Analysis Report Generate Excel - SKYBIZ Cloud ERP Support","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Multi-Dimensional Analysis Report Generate Excel - SKYBIZ Cloud ERP Support","og_description":"Below are guideline(s) to Generate Multi-Dimensional Analysis Report: 1. Choose Multi-Dimensional Analysis 2. Choose the right Query 3. Select the Date and Choose Generate 4. Open the Excel File &nbsp; 5.Select the Cells&gt;&gt;Insert&gt;&gt;PivotTable 6.Click SalesPersonCode and Select Add Row Labels 7. Click hcnetamt and Add to Values &nbsp; Powered By : SKYBIZ \u00ae \u00a0Beyond Cloud ..Read more","og_url":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/","og_site_name":"SKYBIZ Cloud ERP Support","article_published_time":"2020-02-04T07:13:35+00:00","article_modified_time":"2020-02-04T09:11:58+00:00","og_image":[{"width":1577,"height":769,"url":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1.png","type":"image\/png"}],"author":"Technical 1","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Technical 1","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/#article","isPartOf":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/"},"author":{"name":"Technical 1","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/#\/schema\/person\/fbf8363b58da4cbb4f5387de1113725c"},"headline":"Multi-Dimensional Analysis Report Generate Excel","datePublished":"2020-02-04T07:13:35+00:00","dateModified":"2020-02-04T09:11:58+00:00","mainEntityOfPage":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/"},"wordCount":130,"image":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/#primaryimage"},"thumbnailUrl":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1.png","keywords":["Generate","SalesPersonReport"],"articleSection":["0109.Sales Person","0902. Multi-Dimensional Analysis","Cloud@Backend"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/","url":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/","name":"Multi-Dimensional Analysis Report Generate Excel - SKYBIZ Cloud ERP Support","isPartOf":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/#primaryimage"},"image":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/#primaryimage"},"thumbnailUrl":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1.png","datePublished":"2020-02-04T07:13:35+00:00","dateModified":"2020-02-04T09:11:58+00:00","author":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/#\/schema\/person\/fbf8363b58da4cbb4f5387de1113725c"},"breadcrumb":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/#primaryimage","url":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1.png","contentUrl":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-content\/uploads\/2020\/02\/SalesPersonReportGenerate_Step1.png","width":1577,"height":769},{"@type":"BreadcrumbList","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/multi-dimensional-analysis-report-generate_excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/"},{"@type":"ListItem","position":2,"name":"Multi-Dimensional Analysis Report Generate Excel"}]},{"@type":"WebSite","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/#website","url":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/","name":"SKYBIZ Cloud ERP Support","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/#\/schema\/person\/fbf8363b58da4cbb4f5387de1113725c","name":"Technical 1","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g","caption":"Technical 1"},"url":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/author\/technical1\/"}]}},"_links":{"self":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/posts\/2811","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/comments?post=2811"}],"version-history":[{"count":5,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/posts\/2811\/revisions"}],"predecessor-version":[{"id":2831,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/posts\/2811\/revisions\/2831"}],"wp:attachment":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/media?parent=2811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/categories?post=2811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/tags?post=2811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}