[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Bradley, Alexandria,17691 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
| Fernandez, Cesar,20035 | 5694.98 | 0.00 | 3374.99 | 0.00 | 2319.99 |
| Sanders, Stephanie, A,19746 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 822.35 | 467.98 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 637.86 | 518.04 |
| Evans, Gabriel,23487 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Sun, Arturo, C,11498 | 557.54 | 0.00 | 0.00 | 321.57 | 235.97 |
| Henderson, Isabelle, K,16366 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Campbell, Chloe,11212 | 760.93 | 0.00 | 0.00 | 307.78 | 453.15 |
| Rogers, Jade, I,14332 | 102.25 | 0.00 | 0.00 | 44.99 | 57.26 |
| Sanchez, Adrian, L,13179 | 190.17 | 0.00 | 0.00 | 77.92 | 112.25 |
| Wilson, Grace,17539 | 205.92 | 0.00 | 0.00 | 0.00 | 205.92 |
| Brown, Nicholas, S,11506 | 675.64 | 0.00 | 0.00 | 401.27 | 274.37 |
| Russell, Samuel, V,11652 | 310.93 | 0.00 | 0.00 | 34.98 | 275.95 |
| Harris, Samantha, A,24487 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Baker, Isaiah,12106 | 169.54 | 0.00 | 0.00 | 37.29 | 132.25 |
| Hill, Timothy,14871 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| She, Martha, E,22251 | 5971.33 | 3578.27 | 0.00 | 0.00 | 2393.06 |
| Thompson, Ryan, M,11330 | 1111.36 | 0.00 | 0.00 | 623.78 | 487.58 |
| Wright, Carol, C,12928 | 247.41 | 0.00 | 0.00 | 128.46 | 118.95 |
| Nelson, Kevin,14765 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Ramirez, Ian,16678 | 3162.31 | 0.00 | 0.00 | 742.35 | 2419.96 |
| Barnes, Alexandra, P,22268 | 6031.31 | 3578.27 | 0.00 | 0.00 | 2453.04 |
| Griffin, Jason, L,11200 | 1267.11 | 0.00 | 0.00 | 724.21 | 542.90 |
| Evans, Kaylee,19642 | 133.54 | 0.00 | 0.00 | 96.95 | 36.59 |
| Simmons, Dakota, T,14110 | 819.46 | 0.00 | 0.00 | 819.46 | 0.00 |
| Turner, Blake,12136 | 131.74 | 0.00 | 0.00 | 27.28 | 104.46 |
| Howard, Natalie,13491 | 54.96 | 0.00 | 0.00 | 14.98 | 39.98 |
| Flores, Kevin,15878 | 225.92 | 0.00 | 0.00 | 69.97 | 155.95 |
| White, Greg, C,17403 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 116.91 | 97.35 |
| Alexander, Ashley, J,20007 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 488.15 | 522.41 |
| Peterson, Alex, M,13423 | 132.90 | 0.00 | 0.00 | 0.00 | 132.90 |
| Gonzalez, Jackson, S,14480 | 194.94 | 0.00 | 0.00 | 0.00 | 194.94 |
| Bailey, Alexandria, V,13209 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Bell, Gabrielle,22373 | 5976.32 | 3578.27 | 0.00 | 0.00 | 2398.05 |
| Lal, Kyle,17360 | 122.18 | 0.00 | 0.00 | 35.23 | 86.95 |
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 83.96 | 3.99 |
| Garcia, Brandon, V,24418 | 4329.61 | 0.00 | 3578.27 | 751.34 | 0.00 |
| Martinez, Jonathan,13303 | 66.25 | 0.00 | 0.00 | 42.28 | 23.97 |
| Evans, Alexandra,24322 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Williams, Edward, D,14274 | 121.56 | 0.00 | 0.00 | 9.99 | 111.57 |
| Cooper, Brianna,25925 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Cox, Katelyn, B,21742 | 30.97 | 0.00 | 0.00 | 30.97 | 0.00 |
| Watson, Devin, A,18875 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| Ramirez, Garrett, M,17388 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Sanders, Megan, A,15376 | 136.24 | 0.00 | 0.00 | 57.26 | 78.98 |
| James, Zoe, R,14611 | 304.55 | 0.00 | 0.00 | 0.00 | 304.55 |
| Johnson, Anthony, D,27022 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Martin, Brandon, S,21691 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Coleman, Joan, W,26699 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Hughes, Isabella,23048 | 51.46 | 0.00 | 0.00 | 51.46 | 0.00 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 2294.99 | 2398.05 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 1735.98 | 0.00 |
| Peterson, Jessica, M,11868 | 247.01 | 0.00 | 0.00 | 81.94 | 165.07 |
| Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
| Ward, Natalie, J,13241 | 2325.96 | 0.00 | 0.00 | 0.00 | 2325.96 |
| Nath, Kenneth, W,17037 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Stewart, Destiny,13144 | 281.47 | 0.00 | 0.00 | 236.23 | 45.24 |
| Cooper, Ariana,17348 | 205.42 | 0.00 | 0.00 | 84.96 | 120.46 |
| Lewis, Morgan,17410 | 168.74 | 0.00 | 0.00 | 0.00 | 168.74 |
Generated 2026-07-21 21:17:20.002 UTC