[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 408 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Andersen, Dale, B,14992 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Alonso, Roberto, M,14533 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Rai, Sheena,29393 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Rubio, Casey, A,24152 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 0.00 | 3110.05 | 0.00 |
| Hu, Louis,16187 | 34.92 | 0.00 | 0.00 | 0.00 | 34.92 |
| Alonso, Kendra, C,16427 | 2975.02 | 0.00 | 0.00 | 2975.02 | 0.00 |
| Raji, Colin, A,25801 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Pal, Michele,17814 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Ye, Eugene, E,11609 | 6872.11 | 0.00 | 2049.10 | 0.00 | 4823.01 |
| Morgan, Lauren,24217 | 1209.47 | 0.00 | 0.00 | 0.00 | 1209.47 |
| Rubio, Byron,18622 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Ma, Stacey,21840 | 31.27 | 0.00 | 0.00 | 31.27 | 0.00 |
| Lal, Bonnie, A,29445 | 182.78 | 0.00 | 0.00 | 0.00 | 182.78 |
| Robinson, Nicole,28730 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Luo, Alvin,23635 | 2452.34 | 0.00 | 0.00 | 2452.34 | 0.00 |
| Deng, Julie,25631 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ma, Randy, R,24550 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Garcia, Bruce, B,18037 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Pal, Rafael, J,17715 | 2831.53 | 0.00 | 0.00 | 2181.56 | 649.97 |
| Lopez, Allen, O,13821 | 5940.54 | 0.00 | 3578.27 | 0.00 | 2362.27 |
| Alexander, Isabel,22823 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Rubio, Jill,13838 | 140.55 | 0.00 | 0.00 | 0.00 | 140.55 |
| Zhu, Autumn,14840 | 157.96 | 0.00 | 0.00 | 0.00 | 157.96 |
| Ramos, Diana, J,28733 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Patel, Chelsea, P,19938 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Howard, Carlos,27891 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Zeng, Christy, L,15441 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Butler, Blake,13583 | 8375.29 | 3578.27 | 0.00 | 0.00 | 4797.02 |
Generated 2025-12-24 07:44:06.457 UTC