[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 62 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Long, Emily, L,26140 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Vazquez, Daisy, L,25560 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Wang, Curtis, A,13108 | 5718.66 | 0.00 | 0.00 | 2071.42 | 3647.24 |
| Garcia, Andre, H,12705 | 6854.11 | 0.00 | 0.00 | 2049.10 | 4805.01 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 0.00 | 2071.42 | 4779.99 |
| Hu, Krystal, D,13012 | 7017.44 | 0.00 | 0.00 | 2071.42 | 4946.02 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 0.00 | 2071.42 | 4772.52 |
| Wang, Trisha, V,17259 | 4404.73 | 0.00 | 3578.27 | 0.00 | 826.46 |
| Raji, Carl,19595 | 6095.08 | 0.00 | 3578.27 | 0.00 | 2516.81 |
| Martinez, Sarah, S,12670 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Wu, Nuan,29293 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Diaz, Stacy, L,12340 | 6752.13 | 0.00 | 2049.10 | 0.00 | 4703.03 |
| Diaz, Mallory, V,17289 | 106.95 | 0.00 | 0.00 | 0.00 | 106.95 |
| Chander, Alejandro, M,24455 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Alexander, Olivia, L,14667 | 5295.41 | 0.00 | 0.00 | 2049.10 | 3246.31 |
| Rodriguez, Ebony,14517 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Hall, Jesse,26133 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Gonzalez, Jay, C,14238 | 5642.90 | 0.00 | 0.00 | 2049.10 | 3593.80 |
| Gill, Melinda, G,11151 | 8087.31 | 0.00 | 3374.99 | 0.00 | 4712.32 |
| Cai, Jessie, A,12249 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Martinez, Monica, A,14129 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Zeng, Marshall, M,20987 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Powell, Grace, B,29194 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Madan, Geoffrey, M,15241 | 51.91 | 0.00 | 0.00 | 0.00 | 51.91 |
| Martin, Randall, B,19560 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Alvarez, Roy, A,16709 | 143.94 | 0.00 | 0.00 | 0.00 | 143.94 |
| Garcia, Donald,18929 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Kumar, Kenneth,11472 | 8165.82 | 0.00 | 3399.99 | 0.00 | 4765.83 |
| Deng, Colin, B,18299 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Liu, Omar, L,12252 | 3938.95 | 0.00 | 3374.99 | 0.00 | 563.96 |
| Navarro, Marc,16346 | 37.55 | 0.00 | 0.00 | 0.00 | 37.55 |
| Nara, Yolanda,29080 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| She, Latoya, A,11750 | 8148.02 | 0.00 | 3399.99 | 0.00 | 4748.03 |
| Stone, Colin, K,12673 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
| Yang, Shannon,12001 | 8113.01 | 0.00 | 3374.99 | 0.00 | 4738.02 |
| Collins, Logan, H,13983 | 180.41 | 0.00 | 0.00 | 0.00 | 180.41 |
| Alvarez, Philip, A,11123 | 45.88 | 0.00 | 0.00 | 0.00 | 45.88 |
| Kumar, Michele,23107 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Suri, Kaitlin, C,29190 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Wood, Julia, L,12356 | 6810.13 | 0.00 | 2049.10 | 0.00 | 4761.03 |
| Garcia, Charles, M,20250 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Chande, Arturo, H,14860 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Suri, Gerald,13617 | 116.92 | 0.00 | 0.00 | 0.00 | 116.92 |
| Chen, Clarence, R,15147 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Huang, Jorge,17291 | 86.27 | 0.00 | 0.00 | 53.99 | 32.28 |
| Russell, Jonathan,18896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Gonzalez, Summer, L,20266 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Raman, Edgar, A,27596 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Alonso, Gary, C,18767 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Griffin, Grace,11443 | 8235.00 | 0.00 | 3374.99 | 0.00 | 4860.01 |
| Mr., Solanki, Ajay,18295 | 144.27 | 0.00 | 0.00 | 0.00 | 144.27 |
| Dominguez, Kellie, E,17244 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| She, Yolanda, M,18304 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Sharma, Corey, M,17495 | 119.91 | 0.00 | 0.00 | 0.00 | 119.91 |
| Sullivan, Henry, L,20603 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Richardson, Katelyn,18930 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Ashe, Jimmy, S,28959 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Serrano, Dana, S,12678 | 341.43 | 0.00 | 0.00 | 0.00 | 341.43 |
| Andersen, Rafael, E,12691 | 247.46 | 0.00 | 0.00 | 0.00 | 247.46 |
| Xie, Drew, A,20218 | 104.69 | 0.00 | 0.00 | 0.00 | 104.69 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 0.00 | 63.42 |
Generated 2025-12-21 10:38:21.488 UTC