Interpretation Date2 Date2 Z:\Profile\Documents\Date.xlsx FactTable FactTable Z:\Profile\Documents\FactTable.xlsx Sheet1 Date,System.DateTime Day_x0020_Picker,System.String DimDateKeyId,System.Double Sequencenumberweek,System.Double Week_x0020_Picker,System.String 207db377b0f3450a9993c11c0e400d7d Sheet1 Date2.Sheet1 Sheet12 AdjustmentCost,System.Object AdjustmentcostSPLW,System.Double AdjustmentCostSPLY,System.Object AdjustmentSell,System.Object AdjustmentSellSPLW,System.Double AdjustmentSellSPLY,System.Object Calendarid,System.Double DepartmentCode,System.Double DepartmentGST,System.Object DepartmentGSTSPLW,System.Object DepartmentGSTSPLY,System.Object DepartmentName,System.String DepartmentSellEx,System.Object DepartmentSellExSPLW,System.Double DepartmentSellExSPLY,System.Object DepartmentSellInc,System.Object DepartmentSellIncSPLW,System.Double DepartmentSellIncSPLY,System.Object DimCategorisationId,System.Double DimDateKeyId,System.Double MarkdownNumberOfBaskets,System.Object MarkdownNumberOfBasketsSPLW,System.Double MarkdownNumberOfBasketsSPLY,System.Object MarkdownQty,System.Object MarkdownQtySPLW,System.Double MarkdownQtySPLY,System.Object MarkdownSellEx,System.Object MarkdownSellExSPLW,System.Double MarkdownSellExSPLY,System.Object MarkdownSellInc,System.Object MarkdownSellIncSPLW,System.Double MarkdownSellIncSPLY,System.Object NormalCostEx,System.Object NormalSellEx,System.Object NumberOfBaskets,System.Object NumberOfBasketsSPLW,System.Double NumberOfBasketsSPLY,System.Object Promotion1GPEx,System.Object Promotion1SellEx,System.Object Promotion2GPEx,System.Object Promotion2SellEx,System.Object Promotion3GPEx,System.Object Promotion3SellEx,System.Object Promotion4GPEx,System.Object Promotion4SellEx,System.Object PromotionCostEx,System.Object PromotionCostExSPLW,System.Double PromotionCostExSPLY,System.Object PromotionNumberofBaskets,System.Object PromotionNumberofBasketsSPLW,System.Double PromotionNumberofBasketsSPLY,System.Object PromotionSellEx,System.Object PromotionSellExSPLW,System.Double PromotionSellExSPLY,System.Object PromotionSellInc,System.Object PromotionSellIncSPLW,System.Double PromotionSellIncSPLY,System.Object RefundTotalSellInc,System.Object RefundTotalSellIncSPLW,System.Double RefundTotalSellIncSPLY,System.Object ReturnTotalSellInc,System.Object ReturnTotalSellIncSPLW,System.Double ReturnTotalSellIncSPLY,System.Object TotalAvgBasketEx,System.Object TotalAvgBasketExSPLW,System.Double TotalAvgBasketExSPLY,System.Object TotalCostEx,System.Object TotalCostExSPLW,System.Double TotalCostExSPLY,System.Object TotalCostInc,System.Object TotalCostIncSPLW,System.Double TotalCostIncSPLY,System.Object TotalSalesEx,System.Object TotalSalesExSPLW,System.Double TotalSalesExSPLY,System.Object TotalSalesInc,System.Object TotalSalesIncSPLW,System.Double TotalSalesIncSPLY,System.Object 25d822a94dfe4f19b65adc2b9fd3ad41 Sheet12 FactTable.Sheet1 True Name DimDateKeyId b44f8882114b4f068a644299abf84916 Name Relation DimDateKeyId EngineV2 dc380ee9c52c4ef4af55251c29b1eb14 White DimGray 0,0,2600,80 DimGray All;White;1;Solid 1700,40,280,40 Arial,9 Transparent 59153417e95a44d09e5716778b33f443 Sheet12.DepartmentCode e1c82f9fe69c47b2b0154e5582334fff DepartmentCode 0,0,0,0 ComboBox1 Sheet12.DepartmentName 957046af17714f02954bdada4e9f6e89 DepartmentName 0,0,0,0 Multi True DepartmentCode 241, 197, 67 Top, Right, Bottom;White;1;Solid 1700,0,280,40 Transparent 9912c63e3a464ec2a67cac93ce0289f1 0,0,0,0 Text1 0,0,0,0 <font face="Arial" size="10"><text-align="Left"><font-color="Black">Department</font-color></text-align></font> 241, 197, 67 All;White;1;Solid 2000,0,300,40 Transparent 4391b6f29c3d4c6c8d473b9ad218efdb 0,0,0,0 Text2 0,0,0,0 <font face="Arial" size="10"><text-align="Left"><font-color="Black">Day Picker</font-color></text-align></font> DimGray All;White;1;Solid 2320,40,280,40 Arial,9 Transparent 780bc2deaa1a44f8943b3f1393544eef Sheet1.Sequencenumberweek a4df6b29b01a49c58d9824e2ea758c3e Sequencenumberweek 0,0,0,0 ComboBox3 [Sheet1.Week Picker] ea4f738971da48219b930bbbac0d369b Week Picker 0,0,0,0 IsNotNull Week Picker Descending Sequencenumberweek 241, 197, 67 All;White;1;Solid 2320,0,280,40 Transparent d4cb21c7bd0c4935bb50f45e604e8941 0,0,0,0 Text3 0,0,0,0 <font face="Arial" size="10"><text-align="Left"><font-color="Black">Week Picker</font-color></text-align></font> DimGray All;White;1;Solid 2000,40,300,40 Arial,9 Transparent 53bb86ef86b54349a191637fc0974aae Sheet1.DimDateKeyId af6b4274568640fd9fa75f7acbd22b17 DimDateKeyId 0,0,0,0 ComboBox2 [Sheet1.Day Picker] cc3e81d2a4794fb7bbdb4a4ee04b729b Day Picker 0,0,0,0 780bc2deaa1a44f8943b3f1393544eef Multi Descending DimDateKeyId edca7602226c4132a804c2c6729ef97e True 0,0,0,0 Panel1 0,0,0,0 White All;Gray;2;Solid 0,80,300,1500 DimGray All;Gray;1;Solid 20,200,260,180 Arial,14,Bold White Tan 9a51408b079445a4894d00ced38b495a 3,3,3,3 Indicator1 5,5,5,5 SUM([Sheet12.TotalSalesExSPLY]) - SUM([Sheet12.TotalCostExSPLY]) e2f07ed172c3481e96d57d62c5031102 GPExSPLY 2 , 1 0 SUM([Sheet12.TotalSalesEx]) - SUM([Sheet12.TotalCostEx]) 485f6a17a2734044889cf458f2e81260 TotalGPEX DimGray All;Gray;1;Solid 20,560,260,180 Arial,14,Bold White Tan 9bf423bef0a142b7ac55e1f346dc9898 Cart 3,3,3,3 Indicator4 5,5,5,5 SUM([Store Summary.NumberOfBasketsSPLY]) e2f07ed172c3481e96d57d62c5031102 Baskets SPLY 0 , 0 1 False SUM([Store Summary.NumberOfBaskets]) 485f6a17a2734044889cf458f2e81260 Baskets DimGray All;Gray;1;Solid 20,740,260,180 Arial,14,Bold White Tan 848cbaa7ecd54679863759b3e6209037 Cart 3,3,3,3 Indicator5 5,5,5,5 SUM([Store Summary.TotalSalesEx])/SUM([Store Summary.NumberOfBaskets]) e2f07ed172c3481e96d57d62c5031102 AvgBaskets SPLY 2 , 1 0 SUM([Store Summary.TotalSalesEx])/SUM([Store Summary.NumberOfBaskets]) a116ebc6fa5d4b8cba9eab4a12e22585 Avg Basket DimGray All;Gray;1;Solid 20,1100,260,200 Arial,14,Bold White 115945663aaa4747a59624a4fdc931c8 3,3,3,3 Progress2 5,5,5,5 [221:94:89] SUM([Store Summary.TotalSalesEx]) d45824194d3e437bb107bffe4f4531c7 2 , 1 1 % SUM([Store Summary.MarkdownSellEx]) 08abc117b0f343c9947ddd8b065c64ff MarkdownSales DimGray All;Gray;1;Solid 20,920,260,180 Arial,14,Bold White 07fc0dcef5a14e429888eabc40262ce9 3,3,3,3 Progress1 5,5,5,5 [221:94:89] SUM([Store Summary.TotalSalesEx]) d45824194d3e437bb107bffe4f4531c7 2 , 1 1 % SUM([Store Summary.DepartmentSellEx]) 08abc117b0f343c9947ddd8b065c64ff KeyedSales DimGray All;Gray;1;Solid 20,380,260,180 Arial,14,Bold White Tan 98ea3668538e476582bb23d4d027cd26 3,3,3,3 Indicator3 5,5,5,5 (SUM([Store Summary.TotalSalesExSPLY]) - SUM([Store Summary.TotalCostExSPLY]))/SUM([Store Summary.TotalSalesExSPLY]) 8899a6e814e04151be08693b2a49b11d GPSPLY% 2 , 1 1 % (SUM([Sheet12.TotalSalesEx])-SUM([Sheet12.TotalCostEx]))/SUM([Sheet12.TotalSalesEx]) 485f6a17a2734044889cf458f2e81260 GP% DimGray All;Gray;1;Solid 20,1300,260,180 Arial,14,Bold White 0370bd9d3e3a4fca80b3087a86275126 3,3,3,3 Progress3 5,5,5,5 [221:94:89] SUM([Store Summary.TotalSalesEx]) d45824194d3e437bb107bffe4f4531c7 2 , 1 1 % SUM([Store Summary.AdjustmentCost]) 08abc117b0f343c9947ddd8b065c64ff Adj Cost DimGray All;Gray;1;Solid 20,40,260,160 Arial,14,Bold White Tan e9c9fa45d04c491cb8df94d91e03b5a4 0,0,0,0 Indicator2 5,5,5,5 Sum([Sheet12.TotalSalesExSPLY]) 8899a6e814e04151be08693b2a49b11d TotalSalesExSPLY 2 , 1 0 DecimalDigits SUM([Sheet12.TotalSalesEx]) 485f6a17a2734044889cf458f2e81260 TotalSalesEx c79e1bb9fddc44ef9e3580646563b184 0,0,0,0 Panel2 0,0,0,0 Transparent Transparent Transparent All;Gray;2;Solid 1900,80,700,360 1822b704f85846d294abd825c5ce6753 Arial,8 Black

Center Black Arial,8

0,0,0,0 Chart2 5,5,5,5 2 , 1 0 Sum([Sheet12.RefundTotalSellInc]) 4e988d2c6f694555935a7e6cf80e35c7 Refunds Pie Sum([Sheet12.ReturnTotalSellInc]) efc90d12dfd945c2afd5cc6583f87d63 Returns Pie Transparent Transparent Sheet12.DepartmentName 53710452730c4c4e90ff383fe9e27e0d DepartmentName Transparent All;Gray;2;Solid 300,80,1600,780 f8e741b4eadc465c93f65dfbf32f57e8 {Argument} Department ShowDashboard <font face="Arial" size="12"><text-align="Center">{Value}</text-align></font> 0537994acd6d45008f150dcb0cd79f41 Arial,8 Transparent

Transparent Arial,8

0,0,0,0 Chart1 5,5,5,5 [23:70:91] DepartmentName 2 , 1 0 Abbreviation False SUM([Sheet12.TotalSalesEx]) 1faad608c6ff4a34b53d6af9f0a49ba4 TotalSalesEx Black Arial,8 Black Arial,8 Transparent Transparent Transparent All;Gray;2;Solid 1900,440,700,580 07f12ae3e42c48ceb3db7bb8bc13fde8 Arial,8 Black InsideEnd

Black Arial,8

0,0,0,0 Chart5 5,5,5,5 2 , 1 1 % False ((Sum([Sheet12.NormalSellEx])-SUM([Sheet12.NormalCostEx]))/SUM([Sheet12.NormalSellEx])) 4e988d2c6f694555935a7e6cf80e35c7 Normal Pie (Sum([Sheet12.Promotion1GPEx])/SUM([Sheet12.Promotion1SellEx])) efc90d12dfd945c2afd5cc6583f87d63 Special 1 Pie (SUM([Sheet12.Promotion2GPEx]) / SUM([Sheet12.Promotion2SellEx])) caa56907cac64347935710ed3a537c92 Special 2 Pie (SUM([Sheet12.Promotion3GPEx])/SUM([Sheet12.Promotion3SellEx])) f676605ce0cc4587a0019233fb965277 Special 3 Pie (SUM([Sheet12.Promotion4GPEx])/SUM([Sheet12.Promotion4SellEx])) f5a1ae869b13457aacead1668cd0e553 Special 4 Pie Transparent Transparent Sheet12.DepartmentName 24b2f477529241dcb28791742b346c75 DepartmentName Transparent All;Gray;2;Solid 300,860,1600,720 93e4eb7e684b4eedbe89ee137d0636b9 Arial,8 Transparent

Transparent Arial,8

0,0,0,0 Chart4 5,5,5,5 [23:70:91] DepartmentName 2 , 1 1 % False (Sum([Sheet12.TotalSalesEx])-SUM([Sheet12.TotalCostEx]))/SUM([Sheet12.TotalSalesEx]) 9d3b51d8ed09463b88da0d8b79de9b7a GP % Black Arial,8 Black Arial,8 Transparent 1900,1020,680,560 Sheet12.DepartmentName Transparent d8bfe4776477453692b2aaafb4d2cd6d DepartmentName Sum(Sheet12.TotalSalesEx) Transparent Right 8e39c32b94884cdd9a759f1f1f0fbee9 2 , 1 0 Sum(Sheet12.TotalSalesEx) Transparent Right fc9476497a3b41f685aab6f8e98000ae 2 , 1 0 Arial,10 Transparent 926eefcc0b3e46fbaf4e543cb2bb2ec3 Arial,10 Transparent 3,3,3,3 Table1 5,5,5,5 True 0 TotalSalesEx-Sum RunningTotal 6d228e5f8caf4c7ca58658c092e6f763 1600 StoreSummary 2600 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 8/14/2019 4:35:12 PM 6/25/2019 11:49:46 AM Z:\Profile\Downloads\StoreSummary.mrt 68761f689737481383db3d93006ea416 Report Centimeters 2019.3.2.0 CSharp 55, 72, 80 140, 140, 140 221, 75, 57 226, 226, 226 Style1 Green Red