[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1219 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Kari,15235 | 190.89 | 0.00 | 0.00 | 0.00 | 190.89 |
| Martinez, Jay,24592 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Goel, Lacey, N,18704 | 33.26 | 0.00 | 0.00 | 0.00 | 33.26 |
| Lin, Dennis,16169 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Torres, Dwayne, R,17288 | 4426.24 | 0.00 | 3578.27 | 0.00 | 847.97 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| Sharma, Lindsay, E,24478 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Gonzalez, Ivan, C,19625 | 52.77 | 0.00 | 0.00 | 0.00 | 52.77 |
| Zeng, Alvin, M,11118 | 115.85 | 0.00 | 0.00 | 0.00 | 115.85 |
| Deng, Jodi,16161 | 2700.05 | 0.00 | 0.00 | 2049.10 | 650.95 |
| Perry, Maria, N,17728 | 4730.03 | 0.00 | 3578.27 | 0.00 | 1151.76 |
| Sanz, Reginald, K,17522 | 74.95 | 0.00 | 0.00 | 0.00 | 74.95 |
| Ruiz, Kari, L,12695 | 192.97 | 0.00 | 0.00 | 0.00 | 192.97 |
| Bailey, Melissa, C,19572 | 82.25 | 0.00 | 0.00 | 0.00 | 82.25 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 0.00 | 193.97 |
| Ma, Laura, L,24503 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Andersen, Jenny,20259 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Shan, Elijah, L,26795 | 1992.46 | 0.00 | 0.00 | 782.99 | 1209.47 |
| Liang, Amy,16164 | 2639.08 | 0.00 | 0.00 | 2049.10 | 589.98 |
| Butler, Jason,17510 | 4369.74 | 0.00 | 3578.27 | 0.00 | 791.47 |
| Hu, Marshall, H,26797 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Gao, Susan,27471 | 1386.48 | 0.00 | 0.00 | 782.99 | 603.49 |
| Rodriguez, Pedro, L,17911 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Gonzalez, Ebony,11034 | 6491.32 | 0.00 | 3399.99 | 0.00 | 3091.33 |
| Chande, Mindy, V,27472 | 1345.95 | 0.00 | 0.00 | 782.99 | 562.96 |
| Ross, Adam,11099 | 8215.99 | 0.00 | 3399.99 | 0.00 | 4816.00 |
| Goel, Alejandro, K,13077 | 6766.63 | 0.00 | 0.00 | 2049.10 | 4717.53 |
| Dominguez, Raquel, A,27470 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Madan, Terrance,24910 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Xu, Terry,24228 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Xu, Kristen,15751 | 4446.40 | 0.00 | 0.00 | 2071.42 | 2374.98 |
| Hernandez, Bruce,17919 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Ramos, Leslie,15733 | 4443.55 | 0.00 | 0.00 | 2049.10 | 2394.45 |
| Goldberg, Mindy,16159 | 4411.65 | 0.00 | 0.00 | 2071.42 | 2340.23 |
| Suarez, Randall, M,28211 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Zhu, Roger, J,28098 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Sun, Suzanne, P,24587 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Rivera, Steven, T,19083 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 0.00 | 4729.03 |
| Gutierrez, Kari,15756 | 4441.39 | 0.00 | 0.00 | 2071.42 | 2369.97 |
| Lu, Tiffany,22843 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Powell, Aaron,25241 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rai, Melvin, J,24604 | 3681.80 | 0.00 | 0.00 | 3681.80 | 0.00 |
| Sun, Leah,17734 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Fernandez, Shane, A,13127 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Andersen, Marshall, V,15786 | 4366.07 | 0.00 | 0.00 | 2049.10 | 2316.97 |
| Zeng, Micah, A,25561 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Tang, Wayne, S,13090 | 6812.42 | 0.00 | 0.00 | 2049.10 | 4763.32 |
| Xu, Dawn,27873 | 1249.84 | 0.00 | 0.00 | 1249.84 | 0.00 |
| Liu, Suzanne,19594 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Gao, Rosa,26034 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Vazquez, Arthur,28480 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Martinez, Sarah, S,12670 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Chavez, Kurt, C,23563 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Xu, Peter, K,28204 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Xie, Karla,18201 | 4157.73 | 0.00 | 3578.27 | 0.00 | 579.46 |
| Chen, Kristen, L,22002 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Raje, Kelli, A,28136 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Martin, Craig, M,25012 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Huang, Wesley,29320 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
Generated 2026-01-04 05:07:25.413 UTC