[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 37 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jimenez, Victor,11461 | 8089.04 | 0.00 | 3374.99 | 0.00 | 4714.05 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Moreno, Janet, L,15592 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Lopez, Brandy, S,18199 | 99.94 | 0.00 | 0.00 | 0.00 | 99.94 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Ramos, Leslie,15733 | 4443.55 | 0.00 | 0.00 | 2049.10 | 2394.45 |
| Sanchez, Henry,26968 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Xie, Alicia,26427 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Martin, Gerald, K,17284 | 90.25 | 0.00 | 0.00 | 31.27 | 58.98 |
| Serrano, Alberto, L,15800 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Andersen, Jenny,20259 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Sharma, Christian,15809 | 62.59 | 0.00 | 0.00 | 0.00 | 62.59 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 0.00 | 2049.10 | 3599.82 |
| Martinez, Sarah, S,12670 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Chandra, Veronica,14681 | 5178.40 | 0.00 | 0.00 | 2049.10 | 3129.30 |
| Garcia, Harold, K,14087 | 341.97 | 0.00 | 0.00 | 0.00 | 341.97 |
| Tang, Rafael, A,11908 | 8079.05 | 0.00 | 3374.99 | 0.00 | 4704.06 |
| Guo, Lacey,16744 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Madan, Brenda,13043 | 175.93 | 0.00 | 0.00 | 0.00 | 175.93 |
| He, Louis, E,21211 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Luo, Devon, D,22850 | 4657.51 | 0.00 | 0.00 | 2181.56 | 2475.95 |
| Li, Ramon,21248 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
Generated 2025-12-22 02:28:24.096 UTC