[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 30 < SKIP 1000 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gray, Morgan,28307 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Zhang, Ronnie,16656 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Lin, Autumn, E,18272 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Sanz, Gerald, J,17060 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Li, Cedric,27364 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Suarez, Nelson,27355 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Allen, Hailey, C,26759 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Chander, Lindsay, R,19972 | 49.70 | 0.00 | 0.00 | 0.00 | 49.70 |
| Pal, Christine, I,18242 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Martin, Pedro, B,28103 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Barnes, Faith, F,15726 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| Mitchell, Wyatt, A,14048 | 5123.74 | 0.00 | 0.00 | 2071.42 | 3052.32 |
| Cai, Gilbert, J,18256 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Martinez, Ann,12009 | 8195.50 | 0.00 | 3399.99 | 0.00 | 4795.51 |
| Torres, Kellie,19569 | 112.24 | 0.00 | 0.00 | 0.00 | 112.24 |
| Shen, Mitchell, M,22904 | 4759.99 | 0.00 | 0.00 | 2181.56 | 2578.43 |
| Shan, Kristin,23416 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Moreno, Deanna,28941 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Alvarez, Tabitha,15028 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Martinez, Terrance,25718 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Rodriguez, Ebony,14517 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Mehta, Pamela,22005 | 135.46 | 0.00 | 0.00 | 0.00 | 135.46 |
| Allen, Logan,15812 | 81.25 | 0.00 | 0.00 | 0.00 | 81.25 |
| Guo, Cara, R,15721 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Wang, Nathan,14039 | 6808.13 | 0.00 | 0.00 | 2049.10 | 4759.03 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 0.00 | 4693.04 |
| Dominguez, Larry,22197 | 4740.98 | 0.00 | 0.00 | 2181.56 | 2559.42 |
| Gomez, Felicia, J,18219 | 6038.56 | 0.00 | 3578.27 | 2460.29 | 0.00 |
| Arthur, Raymond, S,20228 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Raje, Darrell,20252 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chandra, Gerald,25131 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gill, Dwayne, A,19675 | 198.99 | 0.00 | 0.00 | 0.00 | 198.99 |
| Sanchez, Clifford,21188 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Rana, Jermaine, S,28927 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Chapman, Clifford, C,21168 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Navarro, Cheryl,13109 | 5682.90 | 0.00 | 0.00 | 2049.10 | 3633.80 |
| Jenkins, Noah, A,24379 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Navarro, Mallory,24365 | 3331.03 | 0.00 | 0.00 | 2181.56 | 1149.47 |
| She, Latoya, A,11750 | 8148.02 | 0.00 | 3399.99 | 0.00 | 4748.03 |
| Lal, Kelsey, T,24913 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Gutierrez, Kari,15756 | 4441.39 | 0.00 | 0.00 | 2071.42 | 2369.97 |
| Gao, Gilbert,24165 | 3046.84 | 0.00 | 0.00 | 2443.35 | 603.49 |
| Ortega, Jill, A,20239 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Torres, Melinda, J,14033 | 6809.96 | 0.00 | 0.00 | 2071.42 | 4738.54 |
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 0.00 | 2049.10 | 4742.00 |
| Raman, Cassandra,28718 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Suri, Arthur,26190 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Hernandez, Melinda,16174 | 140.45 | 0.00 | 0.00 | 0.00 | 140.45 |
| Zhang, James,14684 | 38.55 | 0.00 | 0.00 | 0.00 | 38.55 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 2049.10 | 1764.96 |
| Lal, Gabriel,27473 | 1398.46 | 0.00 | 0.00 | 782.99 | 615.47 |
| Madan, Rachael, R,16486 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| She, Jaime, D,28482 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Powell, Lucas, T,18278 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Ferrier, Leslie, M,28535 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Cai, Suzanne,25051 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Chapman, Patricia,12037 | 7107.10 | 0.00 | 3374.99 | 0.00 | 3732.11 |
| Martin, Max, A,16030 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Morgan, Nathaniel, E,16626 | 71.57 | 0.00 | 0.00 | 0.00 | 71.57 |
| Ramirez, Mason, K,25107 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Suri, Jarrod, E,12004 | 8114.04 | 0.00 | 3374.99 | 0.00 | 4739.05 |
Generated 2025-12-24 08:27:45.281 UTC