[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 93 < SKIP 2000 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 0.00 | 2049.10 | 4730.32 |
| Liang, Christy, I,21239 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Nara, Sharon,18482 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Chapman, Patricia,12037 | 7107.10 | 0.00 | 3374.99 | 0.00 | 3732.11 |
| Mr., Spencer, Phil,19960 | 6120.11 | 0.00 | 3578.27 | 0.00 | 2541.84 |
| Carlson, Krista,28209 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 0.00 | 928.49 |
| Chande, Katrina, L,19968 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Moreno, Naomi, C,15601 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Perez, Henry,26752 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Xu, Tara,19592 | 5377.23 | 0.00 | 3578.27 | 0.00 | 1798.96 |
| Kapoor, Rachael, D,11911 | 62.46 | 0.00 | 0.00 | 0.00 | 62.46 |
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 0.00 | 221.91 |
| Parker, Timothy, C,22943 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Evans, Adam, H,25820 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Sara, Jarrod,20626 | 6038.56 | 0.00 | 3578.27 | 0.00 | 2460.29 |
| Suri, Pedro,26422 | 1980.96 | 0.00 | 0.00 | 782.99 | 1197.97 |
| Flores, Miranda,17243 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Nara, Dawn, M,21891 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Li, David, A,21894 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Sun, Leah,17734 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 0.00 | 2071.42 | 4789.02 |
| Dominguez, Roy, C,29189 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Lin, Jaclyn,28721 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Guo, Clarence,20265 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Raji, Arturo,23998 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Black, Peter, E,21213 | 64.26 | 0.00 | 0.00 | 0.00 | 64.26 |
| Yang, Louis, J,23013 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 0.00 | 4693.04 |
| Lal, Mitchell, C,20403 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zhou, Arturo, F,27910 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Henderson, Dalton,24895 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xie, Michele, M,15039 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Kapoor, Dominic, J,16699 | 67.58 | 0.00 | 0.00 | 0.00 | 67.58 |
| Kumar, Michele,23107 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Ramos, Jessie, R,11764 | 8129.02 | 0.00 | 3399.99 | 0.00 | 4729.03 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 7.95 | 71.74 |
| Malhotra, Janelle,26425 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chow, Warren, L,24305 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Srini, Beth, A,25913 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Becker, Grant,21390 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Blanco, Krista, L,27580 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hernandez, Wendy, A,15124 | 122.44 | 0.00 | 0.00 | 0.00 | 122.44 |
| Sanz, Walter, J,18195 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Diaz, Stacy, L,12340 | 6752.13 | 0.00 | 2049.10 | 0.00 | 4703.03 |
| Andersen, Gilbert, T,27353 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Luo, Colin, L,21210 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Wu, Lisa,26158 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Tang, Barbara,27711 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Gonzalez, Jay, C,14238 | 5642.90 | 0.00 | 0.00 | 2049.10 | 3593.80 |
| Nath, Dawn, L,11759 | 8054.05 | 0.00 | 3374.99 | 0.00 | 4679.06 |
| Sanz, Ross,11455 | 8142.03 | 0.00 | 3374.99 | 2319.99 | 2447.05 |
| Powell, Amanda,28113 | 901.35 | 0.00 | 0.00 | 0.00 | 901.35 |
| Hill, Mackenzie,19576 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Chander, Alison,18249 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Kumar, Barbara, N,27499 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Sanz, Arthur,27688 | 166.28 | 0.00 | 0.00 | 166.28 | 0.00 |
| Romero, Jacquelyn,25815 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shan, Peter,24280 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Raman, Candace, M,11766 | 8280.48 | 0.00 | 3399.99 | 0.00 | 4880.49 |
Generated 2025-12-24 06:06:25.257 UTC