[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 0.00 | 4828.51 |
| Fernandez, Rachael, M,23993 | 3072.32 | 0.00 | 0.00 | 2443.35 | 628.97 |
| Mehta, Levi, M,13110 | 5583.94 | 0.00 | 0.00 | 2049.10 | 3534.84 |
| Li, Lisa, J,24600 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nath, Grant, A,28947 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Zhang, Roger,12690 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Zhou, Jon, L,11060 | 8153.02 | 0.00 | 3399.99 | 2319.99 | 2433.04 |
| Navarro, Erik, E,25055 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Kumar, Michele,23107 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Raji, Andres, E,13955 | 6888.44 | 0.00 | 0.00 | 2071.42 | 4817.02 |
| Van, Brenda, J,24890 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Lu, Roger, F,19763 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Kovár, Whitney,13105 | 5585.45 | 0.00 | 0.00 | 2049.10 | 3536.35 |
| Kumar, Colin,29188 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sai, Ross, A,21966 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 64.97 | 156.94 |
| Ruiz, Frank, M,14260 | 3716.23 | 0.00 | 0.00 | 2071.42 | 1644.81 |
| Gill, Jay,27975 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Shan, Eric, L,26771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Chande, Cassie,11103 | 8182.50 | 0.00 | 3374.99 | 2388.45 | 2419.06 |
| Perry, Maria, N,17728 | 4730.03 | 0.00 | 3578.27 | 0.00 | 1151.76 |
| Alonso, Darren,27501 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Gomez, Kathleen, J,16158 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Cai, Willie, S,25960 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 0.00 | 2181.56 | 1209.47 |
| Sanz, Ricky,18251 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Coleman, Luis, L,14230 | 5661.90 | 0.00 | 0.00 | 2049.10 | 3612.80 |
| Guo, Jon,22927 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Sanz, Nelson, M,14056 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Alvarez, Albert, R,16624 | 5938.25 | 3578.27 | 0.00 | 0.00 | 2359.98 |
| Zhou, Colleen,23122 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Washington, Sydney,28924 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sai, Levi,16349 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Martinez, Virginia,13136 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Alonso, Diana, L,24590 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Alexander, Gail, C,14682 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Romero, Billy,20419 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| McDonald, Kaitlin,18493 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Liang, Margaret,17254 | 147.48 | 0.00 | 0.00 | 0.00 | 147.48 |
| Goel, Misty, M,18245 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Lal, Mitchell, C,20403 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Li, Dawn, B,13962 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Arthur, Tammy, L,21363 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moreno, Meghan, J,15152 | 4464.57 | 0.00 | 0.00 | 2049.10 | 2415.47 |
| Romero, Raquel, Z,22916 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Hill, Jennifer,18291 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Lee, Austin,26151 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chapman, Kristi, l,21986 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Sai, Jay, A,23427 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Julie,22959 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Morris, Eduardo,19619 | 112.75 | 0.00 | 0.00 | 0.00 | 112.75 |
| Zhou, Stacey, L,21374 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
Generated 2025-12-21 13:41:14.980 UTC