[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 62 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Watson, Richard,15943 | 365.41 | 0.00 | 0.00 | 154.98 | 210.43 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 94.98 | 59.56 |
| Flores, Jordyn,25288 | 2721.55 | 0.00 | 2181.56 | 0.00 | 539.99 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 66.26 | 773.89 |
| Murphy, Chase, J,24729 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Zhang, Robert,18855 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 71.58 | 124.69 |
| Miller, Kayla, A,23673 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
| Russell, Isabella, A,11507 | 645.78 | 0.00 | 0.00 | 28.48 | 617.30 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Suri, Carolyn, S,12972 | 175.71 | 0.00 | 0.00 | 0.00 | 175.71 |
| Davis, Thomas,16764 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 219.26 | 789.98 |
| Martin, Gina, E,11078 | 793.27 | 0.00 | 0.00 | 158.36 | 634.91 |
| Hayes, Jeremiah, W,20086 | 128.55 | 0.00 | 0.00 | 56.97 | 71.58 |
| Alexander, Ryan, J,14078 | 839.48 | 0.00 | 0.00 | 839.48 | 0.00 |
| Butler, Dalton, A,13345 | 4759.51 | 0.00 | 0.00 | 0.00 | 4759.51 |
| Bennett, Antonio, C,11631 | 707.50 | 0.00 | 0.00 | 216.34 | 491.16 |
| Diaz, Jasmine, A,16098 | 3101.29 | 0.00 | 0.00 | 756.33 | 2344.96 |
| Allen, Jack, M,29137 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Martinez, Dominique,28788 | 8.99 | 0.00 | 0.00 | 8.99 | 0.00 |
| Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 107.26 | 92.94 |
| Wilson, Nathan, L,13936 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Henderson, Stephanie, L,19224 | 352.52 | 0.00 | 0.00 | 0.00 | 352.52 |
| Coleman, Spencer,15993 | 597.26 | 0.00 | 0.00 | 0.00 | 597.26 |
| Perez, Eduardo, M,22895 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 292.94 | 862.58 |
| Clark, Lauren,17034 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Gonzales, Nathan, M,12107 | 222.23 | 0.00 | 0.00 | 32.27 | 189.96 |
| Brown, Nicholas, S,11506 | 675.64 | 0.00 | 0.00 | 121.93 | 553.71 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 76.95 | 93.96 |
| Washington, Thomas, C,27451 | 37.43 | 0.00 | 0.00 | 0.00 | 37.43 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
| Garcia, Christian, J,16491 | 3106.33 | 0.00 | 0.00 | 751.34 | 2354.99 |
| Peterson, Jared,11502 | 829.37 | 0.00 | 0.00 | 171.95 | 657.42 |
| Chen, James, D,11641 | 303.20 | 0.00 | 0.00 | 21.49 | 281.71 |
| Russell, Melanie, B,15478 | 182.83 | 0.00 | 0.00 | 167.85 | 14.98 |
| Bell, Julia,21652 | 2646.06 | 0.00 | 0.00 | 2646.06 | 0.00 |
| Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 118.96 | 533.02 |
| Prasad, Donald,15413 | 318.92 | 0.00 | 0.00 | 123.98 | 194.94 |
| Nelson, Jordan, H,20130 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Wedge, Andrew, T,12060 | 4811.54 | 0.00 | 0.00 | 2418.48 | 2393.06 |
| Bradley, Jocelyn,23022 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 42.59 | 85.21 |
| Flores, Devin, A,15559 | 172.04 | 0.00 | 0.00 | 86.56 | 85.48 |
| Phillips, Andrea,18573 | 83.74 | 0.00 | 0.00 | 0.00 | 83.74 |
| Hu, Gilbert, L,28767 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lee, William,13185 | 149.84 | 0.00 | 0.00 | 69.97 | 79.87 |
| Carter, Isaac,13719 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 118.46 | 605.10 |
| Miller, Eduardo,14561 | 158.84 | 0.00 | 0.00 | 49.97 | 108.87 |
| Gonzalez, Jordan,15157 | 213.94 | 0.00 | 0.00 | 123.98 | 89.96 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 237.82 | 1067.84 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 494.64 | 612.04 |
| Isla, Julian, A,13732 | 108.96 | 0.00 | 0.00 | 4.99 | 103.97 |
| Long, Gabrielle,19830 | 5765.92 | 3374.99 | 0.00 | 0.00 | 2390.93 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Griffin, Isabelle,24986 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Powell, Jordyn, K,15391 | 4828.01 | 0.00 | 0.00 | 0.00 | 4828.01 |
Generated 2025-11-04 10:04:39.314 UTC