[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 250 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Goel, Peter, L,15264 | 38.98 | 0.00 | 0.00 | 8.99 | 29.99 |
| Chander, Cassie, M,18258 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Vazquez, Lawrence,19632 | 56.98 | 0.00 | 0.00 | 56.98 | 0.00 |
| Li, Ramon,21248 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Gill, Gerald, A,28487 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Arun, Candace, J,21393 | 4925.17 | 0.00 | 2443.35 | 0.00 | 2481.82 |
| Alvarez, Albert, R,16624 | 5938.25 | 3578.27 | 0.00 | 0.00 | 2359.98 |
| Raman, Levi,29114 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| She, Marshall, D,18707 | 122.76 | 0.00 | 0.00 | 120.47 | 2.29 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 0.00 | 4812.51 |
| Alvarez, Gloria, B,18297 | 6119.59 | 0.00 | 3578.27 | 2541.32 | 0.00 |
| Jai, Warren, S,16483 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Chande, Lindsay,18244 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Raji, Kate, L,11903 | 8108.04 | 0.00 | 3374.99 | 2294.99 | 2438.06 |
| Vazquez, Arthur,28480 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Brooks, Jared,24476 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Jones, Nathan,15024 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Garcia, Monica, D,20267 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Powell, Lucas, T,18278 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Ortega, Lawrence,14685 | 146.74 | 0.00 | 0.00 | 0.00 | 146.74 |
| Moreno, Randall, F,21209 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Jai, Alvin,19599 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Harris, Eduardo, S,18238 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Shan, Tasha,15192 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Raje, Tara, F,28483 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Chen, Rosa,23435 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Chen, Louis, J,17059 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Jackson, Eduardo, C,11749 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Campbell, Seth,18716 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Carlson, Philip, P,11915 | 8143.00 | 0.00 | 3374.99 | 2369.96 | 2398.05 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 2049.10 | 1764.96 |
| Diaz, Emma, L,18711 | 10.24 | 0.00 | 0.00 | 0.00 | 10.24 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 1205.47 | 0.00 |
| Shen, Wayne, P,23647 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Pal, Dustin,26588 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Lu, Willie,21191 | 4169.33 | 0.00 | 2443.35 | 0.00 | 1725.98 |
| Rai, Tonya,25243 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Romero, Meredith, J,29452 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Bailey, Melissa, C,19572 | 82.25 | 0.00 | 0.00 | 0.00 | 82.25 |
| King, Hailey, A,28214 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Deng, Latoya, H,21969 | 4759.47 | 0.00 | 0.00 | 2181.56 | 2577.91 |
| Gonzalez, Deanna, S,15204 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Parker, Evan, R,18729 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Foster, Maria, E,28715 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Murphy, Alexa,18276 | 6106.60 | 0.00 | 3578.27 | 0.00 | 2528.33 |
| Blanco, Wendy, J,19604 | 171.73 | 0.00 | 0.00 | 0.00 | 171.73 |
| Nath, Tasha, J,18487 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Lu, Jaclyn, D,11047 | 6582.33 | 3399.99 | 0.00 | 0.00 | 3182.34 |
| Browning, Jay, M,24251 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| She, Katie, B,11965 | 118.74 | 0.00 | 0.00 | 94.25 | 24.49 |
| Guo, Cara, R,15721 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Edwards, Kaylee, M,22851 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| _SUM | 9051988.22 | 588293.38 | 2369718.48 | 2452674.72 | 3641301.64 |
| Mehta, Brett,11450 | 8173.26 | 0.00 | 3374.99 | 2370.22 | 2428.05 |
| Raji, Warren, J,26796 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Rana, Carla, K,19593 | 5306.54 | 0.00 | 3578.27 | 0.00 | 1728.27 |
| Shan, Jaime,22020 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Sanchez, Olivia, J,14278 | 177.46 | 0.00 | 0.00 | 0.00 | 177.46 |
| Lopez, Isaac,27692 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Chapman, Patricia,12037 | 7107.10 | 0.00 | 3374.99 | 0.00 | 3732.11 |
Generated 2025-11-03 19:29:58.588 UTC