[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 220 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| King, Sara,22354 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Miller, Jill,12914 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Ross, David, M,17143 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Baker, Isaiah,12106 | 169.54 | 0.00 | 0.00 | 0.00 | 169.54 |
| Gray, Marcus, T,18389 | 2401.45 | 0.00 | 0.00 | 0.00 | 2401.45 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Taylor, Zachary, M,27082 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Griffin, Cassidy,26496 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Cooper, Christina, C,26512 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Jai, Connor, D,27253 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Davis, Emily,27267 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Coleman, Jennifer, L,27298 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Kelly, Bryan,21349 | 2989.38 | 0.00 | 0.00 | 2989.38 | 0.00 |
| Coleman, Vanessa,21589 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Flores, Kevin,15878 | 225.92 | 0.00 | 0.00 | 69.97 | 155.95 |
| Anand, Brendan, L,19847 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Henderson, Jeremiah, D,18961 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Moore, Wyatt, F,18971 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Turner, Blake,12136 | 131.74 | 0.00 | 0.00 | 0.00 | 131.74 |
| Thompson, Lucas, O,21277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 0.00 | 180.79 |
| Green, Samuel, D,14096 | 174.73 | 0.00 | 0.00 | 0.00 | 174.73 |
| Foster, Aaron,15566 | 4912.47 | 0.00 | 0.00 | 0.00 | 4912.47 |
| Mr., Sandstone, John, J,12903 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Ruiz, Carrie, D,18644 | 135.44 | 0.00 | 0.00 | 100.46 | 34.98 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Johnson, Ian, E,21732 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 160.51 | 764.10 |
| Edwards, Eric,24627 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Hall, Morgan,21726 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Perez, Sydney, C,22117 | 4158.24 | 3578.27 | 0.00 | 0.00 | 579.97 |
| Morris, Abigail, C,28776 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Dominguez, Meghan,14370 | 122.56 | 0.00 | 0.00 | 0.00 | 122.56 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 237.82 | 1067.84 |
| Ross, Isabelle, D,18554 | 155.45 | 0.00 | 0.00 | 69.97 | 85.48 |
| Flores, Zachary, H,23376 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Campbell, Kevin, S,12177 | 4811.50 | 0.00 | 0.00 | 2404.46 | 2407.04 |
| Brown, Nicholas, S,11506 | 675.64 | 0.00 | 0.00 | 121.93 | 553.71 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 66.26 | 773.89 |
| Thompson, Kaitlyn, L,12430 | 223.93 | 0.00 | 0.00 | 0.00 | 223.93 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 34.98 | 240.52 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Lal, Jonathan,20096 | 71.46 | 0.00 | 0.00 | 0.00 | 71.46 |
| Walker, Hunter,27100 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Green, Gabrielle, M,21815 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Anderson, Lucas,29266 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bailey, Morgan, E,21354 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 219.26 | 789.98 |
| Garcia, Cameron,18641 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 81.49 | 917.73 |
| Navarro, Jerome, B,11519 | 717.28 | 0.00 | 0.00 | 22.18 | 695.10 |
Generated 2025-11-06 05:26:27.656 UTC