[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ramos, Dana, D,25919 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Tang, April, A,25935 | 1256.03 | 0.00 | 699.10 | 0.00 | 556.93 |
| Lal, Alicia,15734 | 4426.41 | 0.00 | 0.00 | 2071.42 | 2354.99 |
| Tang, Nina,27485 | 1354.71 | 0.00 | 0.00 | 782.99 | 571.72 |
| Perez, Ross, E,14307 | 196.26 | 0.00 | 0.00 | 0.00 | 196.26 |
| Li, Dawn, B,13962 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Liang, Margaret,17254 | 147.48 | 0.00 | 0.00 | 0.00 | 147.48 |
| Sanchez, Manuel,15126 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Johnson, Morgan, E,12011 | 4735.81 | 0.00 | 3374.99 | 0.00 | 1360.82 |
| Lal, Tommy,14516 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Vazquez, Lawrence,19632 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 0.00 | 193.97 |
| Xu, Kelvin,18305 | 160.55 | 0.00 | 0.00 | 0.00 | 160.55 |
| Zeng, Alvin, M,11118 | 115.85 | 0.00 | 0.00 | 0.00 | 115.85 |
| Alexander, David,15783 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Xie, Kelli, J,20452 | 6156.70 | 0.00 | 3578.27 | 0.00 | 2578.43 |
| Hernandez, Frank, G,22198 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Huang, Willie, C,28133 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Lin, Clayton, M,27492 | 1344.91 | 0.00 | 0.00 | 782.99 | 561.92 |
| Moreno, Marc,13024 | 2665.06 | 0.00 | 0.00 | 2049.10 | 615.96 |
| Chandra, Tina, S,13974 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 0.00 | 2049.10 | 3599.82 |
| Carlson, Byron,11900 | 8257.01 | 0.00 | 3399.99 | 0.00 | 4857.02 |
| Luo, Maurice, C,27491 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gonzalez, Clifford,24505 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Sanders, Gabriella,11906 | 8151.00 | 0.00 | 3374.99 | 0.00 | 4776.01 |
| She, Tamara, M,14224 | 5621.22 | 0.00 | 0.00 | 2049.10 | 3572.12 |
| Madan, Meagan,11767 | 8319.51 | 0.00 | 3399.99 | 0.00 | 4919.52 |
| Hernandez, Hailey, A,18727 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 0.00 | 230.25 |
| Rai, Grant, R,12573 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Shen, Lindsey,26560 | 1396.44 | 0.00 | 0.00 | 782.99 | 613.45 |
| Long, Nicole, C,13624 | 114.97 | 0.00 | 0.00 | 0.00 | 114.97 |
| Beck, Alicia, L,17248 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Sharma, Christian,15809 | 62.59 | 0.00 | 0.00 | 0.00 | 62.59 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Chande, Warren,17307 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Diaz, Derrick, R,14853 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Hernandez, Philip,21193 | 3905.52 | 0.00 | 2181.56 | 0.00 | 1723.96 |
| Anand, Andrés,11096 | 8063.04 | 0.00 | 3374.99 | 0.00 | 4688.05 |
| Collins, Rebecca, M,26153 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Guo, Martha, A,28536 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Edwards, Kaylee, M,22851 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Kovár, Donald, M,24277 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Madan, Carla, D,28135 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Nara, Gregory,26651 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 2294.99 | 2419.06 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Vazquez, Ross,11148 | 126.24 | 0.00 | 0.00 | 0.00 | 126.24 |
| Rodriguez, Toni, J,25251 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ma, Bianca,19798 | 128.44 | 0.00 | 0.00 | 0.00 | 128.44 |
| Wang, Crystal, C,11112 | 8295.02 | 0.00 | 3374.99 | 0.00 | 4920.03 |
| Russell, Alexis, L,13634 | 234.93 | 0.00 | 0.00 | 0.00 | 234.93 |
| Henderson, Wyatt,16697 | 87.08 | 0.00 | 0.00 | 0.00 | 87.08 |
| Cox, Jared, E,28114 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Gonzalez, Joel, A,15043 | 3846.89 | 0.00 | 0.00 | 2071.42 | 1775.47 |
| Gao, Arturo,28714 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Blanco, Larry, E,21216 | 4935.67 | 0.00 | 2443.35 | 0.00 | 2492.32 |
| Lal, Karl, R,14264 | 5217.73 | 0.00 | 0.00 | 2822.76 | 2394.97 |
| Rodriguez, Rachael, M,11944 | 4776.27 | 0.00 | 3374.99 | 0.00 | 1401.28 |
Generated 2026-01-04 05:27:33.204 UTC