[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 20 < SKIP 62 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 0.00 | 806.76 |
| Moore, Lucas, J,15021 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hernandez, Mathew, A,15184 | 4441.38 | 0.00 | 0.00 | 2071.42 | 2369.96 |
| Li, Justin,14124 | 57.59 | 0.00 | 0.00 | 0.00 | 57.59 |
| Patel, Toni, E,25829 | 1894.07 | 0.00 | 699.10 | 0.00 | 1194.97 |
| Guo, Brent, J,25945 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Rai, Nina,14018 | 63.87 | 0.00 | 0.00 | 0.00 | 63.87 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Rana, Stanley, J,22919 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Suri, Cesar,17512 | 4170.54 | 0.00 | 3578.27 | 592.27 | 0.00 |
| Xu, Edwin, J,25272 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Cai, Suzanne,25051 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Raji, Jaclyn,18289 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Gutierrez, Cheryl, O,25213 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Rodriguez, Geoffrey,20817 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Xu, Rafael, N,21195 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Nara, Derek, A,26139 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Diaz, Megan, A,24303 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Cai, Vincent, L,11757 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Alan, Jamie, S,21224 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Vazquez, Daisy, L,25560 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Chen, Alisha, J,14225 | 5603.92 | 0.00 | 0.00 | 2049.10 | 3554.82 |
| Lal, Tommy,14516 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| She, Valerie, C,20226 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
| Alvarez, Rodney, D,29286 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perez, Bryant, L,15042 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Gonzalez, Phillip, N,18207 | 6089.59 | 0.00 | 3578.27 | 2511.32 | 0.00 |
| Allen, Hailey, C,26759 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Shan, Mario,25271 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Ma, Autumn,20994 | 4191.72 | 0.00 | 3578.27 | 0.00 | 613.45 |
| Andersen, Calvin,22920 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Subram, Arthur, E,27350 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Sun, Todd,22018 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Clark, Sydney,16610 | 67.58 | 0.00 | 0.00 | 0.00 | 67.58 |
| Sanders, Gabriella,11906 | 8151.00 | 0.00 | 3374.99 | 0.00 | 4776.01 |
| Ye, Edwin,18334 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| She, Candice,29178 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Perez, Preston,12370 | 61.53 | 0.00 | 0.00 | 0.00 | 61.53 |
| Martin, Ricky, C,16608 | 101.57 | 0.00 | 0.00 | 0.00 | 101.57 |
| Travers, Danny,12587 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Gonzalez, Ann,11894 | 8223.00 | 0.00 | 3374.99 | 0.00 | 4848.01 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 0.00 | 2071.42 | 4793.53 |
| Kumar, Alison,21200 | 3932.54 | 0.00 | 2181.56 | 0.00 | 1750.98 |
| Rodriguez, Allen, L,17732 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Ramirez, Cole, E,13616 | 6872.06 | 0.00 | 0.00 | 2049.10 | 4822.96 |
| Nara, Willie,24460 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Kapoor, Denise, M,18725 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Sai, Francisco, W,18766 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Rodriguez, Brett,25134 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Li, Karen, K,17921 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Kapoor, Abby, J,29054 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Zeng, Barbara,23102 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Raman, Virginia,26159 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gill, Alberto, P,17733 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Sanz, Jimmy,25810 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Suarez, Lawrence, C,26131 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Kapoor, Jay, F,21956 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Martinez, Tina, J,18461 | 4748.24 | 0.00 | 3578.27 | 0.00 | 1169.97 |
Generated 2025-12-23 11:58:22.282 UTC