[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 < SKIP 1062 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Roberts, Thomas, J,21939 | 4163.24 | 0.00 | 3578.27 | 0.00 | 584.97 |
| Harris, Noah,29256 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Roberts, Carlos,23196 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Patterson, Grace, M,27560 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Moore, Andrew, A,13944 | 150.13 | 0.00 | 0.00 | 0.00 | 150.13 |
| Peterson, Alex, M,13423 | 132.90 | 0.00 | 0.00 | 0.00 | 132.90 |
| Flores, Megan, N,23074 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Jenkins, Austin, D,15748 | 296.91 | 0.00 | 0.00 | 0.00 | 296.91 |
| Luo, Jodi,29213 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 0.00 | 999.22 |
| Long, Sarah,17372 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Peterson, Jessica, M,11868 | 247.01 | 0.00 | 0.00 | 61.97 | 185.04 |
| James, Juan,23267 | 4862.09 | 0.00 | 3578.27 | 0.00 | 1283.82 |
| Gonzales, Jordan,23681 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Jai, Hunter, M,28272 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Lee, Alexander, S,18356 | 149.91 | 0.00 | 0.00 | 0.00 | 149.91 |
| Watson, Erin, B,22772 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Washington, Robert, J,14906 | 143.95 | 0.00 | 0.00 | 0.00 | 143.95 |
| Miller, Kayla, A,23673 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Simmons, Jose,24647 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Garcia, Chloe, M,11037 | 2374.23 | 0.00 | 0.00 | 2374.23 | 0.00 |
| Kelly, Erin, D,23513 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Yuan, Carly,19839 | 194.96 | 0.00 | 0.00 | 0.00 | 194.96 |
| Rogers, Olivia,12020 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Sanchez, Adrian, L,13179 | 190.17 | 0.00 | 0.00 | 0.00 | 190.17 |
| Foster, Abigail,19823 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Jenkins, Dakota, D,20679 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 0.00 | 87.95 |
| Hayes, Logan, J,19026 | 113.24 | 0.00 | 0.00 | 0.00 | 113.24 |
| Evans, Dalton, E,12710 | 4774.04 | 0.00 | 0.00 | 0.00 | 4774.04 |
| Washington, Hailey, S,25885 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Allen, Madeline,29240 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Alexander, Nathan, A,18795 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Stewart, Grace, H,24773 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Moore, Chloe, L,26269 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Yang, Aaron, C,25196 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Perry, Melissa,22128 | 4142.23 | 0.00 | 3578.27 | 0.00 | 563.96 |
| Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Henderson, Logan, C,22366 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Walker, John, M,28589 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Flores, Julian,15846 | 4943.32 | 0.00 | 0.00 | 0.00 | 4943.32 |
| Nelson, Luis,23488 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Campbell, Isabella, C,20350 | 3226.90 | 0.00 | 0.00 | 2071.42 | 1155.48 |
| Bailey, Olivia,23892 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nelson, James, L,24525 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 0.00 | 676.93 |
| Morris, Chase, F,26789 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Coleman, Ashley,27297 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Lal, Kyle,17360 | 122.18 | 0.00 | 0.00 | 0.00 | 122.18 |
| Torres, Victoria,17551 | 160.92 | 0.00 | 0.00 | 0.00 | 160.92 |
| Fernandez, Cesar,20035 | 5694.98 | 0.00 | 3374.99 | 0.00 | 2319.99 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Ye, Alisha, J,22008 | 4141.23 | 0.00 | 3578.27 | 0.00 | 562.96 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Long, Rachel,28283 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hall, Kaylee, E,19751 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Martin, Joshua, A,27607 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 96.07 | 913.17 |
| Harris, Seth, M,16140 | 2528.33 | 0.00 | 0.00 | 0.00 | 2528.33 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
Generated 2025-12-24 07:03:37.686 UTC