[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 29 > < TAKE 48 >
48 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Long, Rachel,28283 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Williams, Morgan, C,20373 | 3226.90 | 0.00 | 0.00 | 2071.42 | 1155.48 |
| Taylor, Natalie, M,14338 | 828.74 | 0.00 | 0.00 | 0.00 | 828.74 |
| Foster, Carson, L,16959 | 135.35 | 0.00 | 0.00 | 0.00 | 135.35 |
| Zhang, Heather,16654 | 3056.32 | 0.00 | 0.00 | 0.00 | 3056.32 |
| Flores, Cassidy, L,23368 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Russell, Gail, L,21263 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Harris, Samantha, A,24487 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Robinson, Zachary, L,13709 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Hughes, Justin, M,18122 | 2439.99 | 0.00 | 0.00 | 0.00 | 2439.99 |
| Torres, Pedro, E,16958 | 168.02 | 0.00 | 0.00 | 0.00 | 168.02 |
| Barnes, Kaitlyn, Z,15162 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 37.29 | 162.91 |
| Bailey, Maria, C,19150 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ward, Lucas, N,18363 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Patterson, Maria, G,13330 | 94.95 | 0.00 | 0.00 | 0.00 | 94.95 |
| Li, Kevin, S,25188 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Raman, Emmanuel, W,19554 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Hughes, Edward,20023 | 4530.47 | 0.00 | 3374.99 | 0.00 | 1155.48 |
| Sanchez, Alex, K,13101 | 4736.03 | 0.00 | 0.00 | 0.00 | 4736.03 |
| Thomas, Ian,19118 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Hall, Eduardo,16847 | 189.94 | 0.00 | 0.00 | 0.00 | 189.94 |
| Griffin, Julian, M,11328 | 4718.04 | 0.00 | 0.00 | 2319.99 | 2398.05 |
| Hughes, Brittany,14387 | 898.46 | 0.00 | 0.00 | 0.00 | 898.46 |
| Turner, Mary,22015 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhao, Karen, L,25408 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Campbell, Hailey,15507 | 267.84 | 0.00 | 0.00 | 228.96 | 38.88 |
| Phillips, James, G,16846 | 180.95 | 0.00 | 0.00 | 0.00 | 180.95 |
| Adams, Mason, T,20528 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 0.00 | 170.91 |
| Perry, Justin, E,16758 | 3062.34 | 0.00 | 0.00 | 0.00 | 3062.34 |
| Parker, Jennifer, D,22118 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Thompson, Blake,18390 | 141.96 | 0.00 | 0.00 | 0.00 | 141.96 |
| Martinez, Grace, M,17385 | 208.69 | 0.00 | 0.00 | 0.00 | 208.69 |
| Torres, Victoria,17551 | 160.92 | 0.00 | 0.00 | 0.00 | 160.92 |
| Jones, Nicole,14504 | 112.27 | 0.00 | 0.00 | 0.00 | 112.27 |
| Mehta, Carmen, C,27436 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Luo, Franklin, J,22027 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Coleman, Logan,18686 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Perez, Timothy, L,22730 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Morgan, Juan, C,18821 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Patterson, Alexis,21348 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Cox, Lucas, J,25393 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 0.00 | 4745.02 |
| Perry, Dalton, A,16149 | 192.04 | 0.00 | 0.00 | 0.00 | 192.04 |
| Flores, Devin, A,15559 | 172.04 | 0.00 | 0.00 | 0.00 | 172.04 |
| Perry, Melissa,22128 | 4142.23 | 0.00 | 3578.27 | 0.00 | 563.96 |
| Alexander, Jordan,21412 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
Generated 2025-12-23 04:46:52.157 UTC