[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Flores, Arianna,21727 | 4132.24 | 3578.27 | 0.00 | 0.00 | 553.97 |
| Cooper, Brian, L,13760 | 128.84 | 0.00 | 0.00 | 0.00 | 128.84 |
| James, Sara,19802 | 3374.99 | 3374.99 | 0.00 | 0.00 | 0.00 |
| Flores, Emma, P,15543 | 180.94 | 0.00 | 0.00 | 78.98 | 101.96 |
| Green, Isabella,26620 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| Ross, Elizabeth, E,14118 | 4741.34 | 0.00 | 0.00 | 2322.28 | 2419.06 |
| Alexander, Aidan,17387 | 148.19 | 0.00 | 0.00 | 148.19 | 0.00 |
| Gonzales, Ryan, M,17373 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Yang, Justin, S,15363 | 4719.04 | 0.00 | 0.00 | 0.00 | 4719.04 |
| Collins, Hailey,11709 | 325.89 | 0.00 | 0.00 | 91.48 | 234.41 |
| Ye, Alisha, J,22008 | 4141.23 | 3578.27 | 0.00 | 0.00 | 562.96 |
| Rogers, Bryce,17402 | 2304.98 | 0.00 | 0.00 | 0.00 | 2304.98 |
| Mitchell, Lucas, C,19829 | 4533.45 | 3374.99 | 0.00 | 0.00 | 1158.46 |
| Sanz, Lori, L,23865 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Martin, Lucas, L,22114 | 4183.23 | 3578.27 | 0.00 | 0.00 | 604.96 |
| Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 283.37 | 1107.18 |
| Gonzales, Jasmine, C,18392 | 2342.93 | 0.00 | 0.00 | 0.00 | 2342.93 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 511.23 | 794.43 |
| Murphy, Emma,19844 | 5807.93 | 3374.99 | 0.00 | 0.00 | 2432.94 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 226.90 | 783.66 |
| Watson, Shelby, J,14911 | 867.97 | 0.00 | 0.00 | 0.00 | 867.97 |
| Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 0.00 | 131.54 |
| Morris, Abigail, C,28776 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 249.40 | 474.16 |
| Martin, Xavier,22233 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Jenkins, Austin, D,15748 | 296.91 | 0.00 | 0.00 | 0.00 | 296.91 |
| Diaz, Luis, D,11203 | 801.77 | 0.00 | 0.00 | 317.50 | 484.27 |
| Adams, Julia, N,26073 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Sandberg, Isaac,13350 | 53.97 | 0.00 | 0.00 | 39.99 | 13.98 |
| James, Bryce,13466 | 133.45 | 0.00 | 0.00 | 0.00 | 133.45 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 187.43 | 447.41 |
| Jones, Dalton, T,18951 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Henderson, Gabrielle, B,18603 | 1205.47 | 0.00 | 0.00 | 1205.47 | 0.00 |
| Gonzalez, Jordan,15157 | 213.94 | 0.00 | 0.00 | 198.96 | 14.98 |
| Washington, Christian, R,26686 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzalez, Madeline, B,18922 | 2326.96 | 0.00 | 0.00 | 0.00 | 2326.96 |
| Lewis, Seth,26782 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Barnes, Blake, A,17865 | 1789.97 | 0.00 | 0.00 | 0.00 | 1789.97 |
| Green, Marcus, C,15974 | 208.41 | 0.00 | 0.00 | 91.95 | 116.46 |
| Gonzales, Melanie, C,18089 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 156.71 | 683.44 |
| Phillips, Haley, B,28079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| King, Morgan,19681 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Howard, Erin, L,18362 | 1725.21 | 0.00 | 0.00 | 0.00 | 1725.21 |
| Collins, Luis, J,22765 | 5978.61 | 0.00 | 3578.27 | 0.00 | 2400.34 |
| Washington, Alexandra, E,15498 | 256.52 | 0.00 | 0.00 | 223.92 | 32.60 |
| Moore, Taylor, A,19987 | 4564.45 | 0.00 | 3374.99 | 0.00 | 1189.46 |
| Yuan, Carly,19839 | 194.96 | 0.00 | 0.00 | 69.97 | 124.99 |
| Turner, Courtney, A,22975 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Bennett, Jordyn, L,22230 | 4223.23 | 0.00 | 3578.27 | 0.00 | 644.96 |
| Perez, Eduardo, M,22895 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Wood, Gabrielle, S,28787 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Stewart, Katherine, Z,22901 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Carter, Jose, H,12532 | 235.72 | 0.00 | 0.00 | 0.00 | 235.72 |
| Thomas, Alexandra, C,23172 | 4809.39 | 0.00 | 3578.27 | 1231.12 | 0.00 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 128.21 | 475.32 |
| Green, Gabrielle, M,21815 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Hill, Kaitlyn, M,24659 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Richardson, Caitlin, T,23057 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Zukowski, Jake,22058 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Russell, Jacqueline,18391 | 100.96 | 0.00 | 0.00 | 100.96 | 0.00 |
| Anderson, Destiny,12895 | 336.65 | 0.00 | 0.00 | 37.27 | 299.38 |
| Ramirez, Abigail, S,15859 | 74.14 | 0.00 | 0.00 | 24.27 | 49.87 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 283.45 | 725.79 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 104.97 | 182.73 |
| Alexander, Edward, E,18524 | 195.95 | 0.00 | 0.00 | 0.00 | 195.95 |
| Murphy, Catherine, L,16506 | 92.05 | 0.00 | 0.00 | 30.97 | 61.08 |
| Price, Lauren, J,14079 | 184.74 | 0.00 | 0.00 | 37.29 | 147.45 |
| Harris, Isabella,17119 | 214.90 | 0.00 | 0.00 | 214.90 | 0.00 |
| Foster, Abigail,19823 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 100.46 | 898.76 |
| Brooks, Bryce,12061 | 140.17 | 0.00 | 0.00 | 125.19 | 14.98 |
| Young, Julia, J,27414 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mitchell, Kaylee, R,14566 | 401.49 | 0.00 | 0.00 | 195.59 | 205.90 |
| Smith, Katherine, J,13197 | 105.19 | 0.00 | 0.00 | 49.97 | 55.22 |
| Griffin, Seth, R,17585 | 164.46 | 0.00 | 0.00 | 78.98 | 85.48 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 496.36 | 659.16 |
| Taylor, Taylor,15905 | 4899.02 | 0.00 | 0.00 | 0.00 | 4899.02 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 94.96 | 180.54 |
| Nath, Carl, H,29001 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Perry, Jackson, J,21306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Turner, Timothy, C,14641 | 119.86 | 0.00 | 0.00 | 49.97 | 69.89 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Patterson, Maria, G,13330 | 94.95 | 0.00 | 0.00 | 79.97 | 14.98 |
| Williams, Ethan,24309 | 4793.12 | 0.00 | 3578.27 | 0.00 | 1214.85 |
| Allen, Amanda,22353 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
| Richardson, Melissa, E,11132 | 2371.94 | 0.00 | 0.00 | 2371.94 | 0.00 |
| Walker, Brandon, J,15916 | 4793.27 | 0.00 | 0.00 | 0.00 | 4793.27 |
| Walker, John, M,28589 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Martin, Kellie, R,28195 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 134.95 | 91.48 |
| Stewart, Alexandria,17476 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Morgan, Timothy,14633 | 242.50 | 0.00 | 0.00 | 95.55 | 146.95 |
| Powell, Angela, R,12970 | 471.11 | 0.00 | 0.00 | 56.96 | 414.15 |
| Moore, Matthew, W,13267 | 109.95 | 0.00 | 0.00 | 74.98 | 34.97 |
| Thomas, Edward, E,19147 | 133.71 | 0.00 | 0.00 | 0.00 | 133.71 |
| Prasad, Molly,24392 | 4329.61 | 0.00 | 3578.27 | 751.34 | 0.00 |
| Campbell, Chloe,11212 | 760.93 | 0.00 | 0.00 | 307.78 | 453.15 |
| Lopez, Carlos,18617 | 1147.77 | 0.00 | 0.00 | 1147.77 | 0.00 |
| Hayes, Jason,26176 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cook, Megan, J,20299 | 56.97 | 0.00 | 0.00 | 56.97 | 0.00 |
| Rogers, Andrea, L,14328 | 308.66 | 0.00 | 0.00 | 155.23 | 153.43 |
| Anderson, Emma, A,18580 | 1170.48 | 0.00 | 0.00 | 1170.48 | 0.00 |
| Sanchez, Allison,16667 | 41.72 | 0.00 | 0.00 | 0.00 | 41.72 |
| Sanchez, Adrian, L,13179 | 190.17 | 0.00 | 0.00 | 77.92 | 112.25 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 74.98 | 197.71 |
| Gonzales, Luis,15856 | 116.25 | 0.00 | 0.00 | 116.25 | 0.00 |
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 116.91 | 97.35 |
| Washington, Caroline, D,23114 | 5996.32 | 0.00 | 3578.27 | 0.00 | 2418.05 |
| Russell, Xavier,12964 | 119.95 | 0.00 | 0.00 | 29.99 | 89.96 |
| Bryant, Kyle,23164 | 4807.10 | 0.00 | 3578.27 | 1228.83 | 0.00 |
| Watson, Olivia, S,13860 | 93.85 | 0.00 | 0.00 | 54.97 | 38.88 |
| Bryant, Isabella, L,22995 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Brooks, Victoria, H,16479 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Phillips, Jackson, D,23378 | 5317.23 | 0.00 | 3578.27 | 0.00 | 1738.96 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 34.89 | 66.96 |
| Harris, Megan,23281 | 4828.11 | 0.00 | 3578.27 | 1249.84 | 0.00 |
| Jones, Kayla, C,18541 | 94.26 | 0.00 | 0.00 | 69.99 | 24.27 |
| Ware, Dennis, L,23725 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 441.44 | 405.33 |
| Alexander, Ashley, J,20007 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Nelson, James, L,24525 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
Generated 2024-09-20 00:06:38.220 UTC