[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 18 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Washington, Haley, F,23904 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Carlson, Linda, J,12609 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Cai, Rosa,22618 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Young, Gabriella, M,19305 | 1622.40 | 0.00 | 0.00 | 1000.44 | 621.96 |
| Carlson, Tyrone, S,22662 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sara, Toni, E,14146 | 6750.56 | 0.00 | 3578.27 | 827.33 | 2344.96 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Gutierrez, Marie, F,29431 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Ruiz, Marc, D,12545 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Harrison, Reginald, M,23774 | 1234.45 | 0.00 | 0.00 | 0.00 | 1234.45 |
| Roberts, Gabriella, J,16553 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Lal, Lacey, L,23751 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hernandez, Francis,21103 | 2506.95 | 0.00 | 0.00 | 782.99 | 1723.96 |
| He, Alan, A,12210 | 6825.45 | 0.00 | 0.00 | 2071.42 | 4754.03 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Sun, Stacey, S,19361 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Rodriguez, Bruce,28473 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Diaz, Blake, E,18135 | 6921.58 | 0.00 | 0.00 | 2181.56 | 4740.02 |
| Chen, Wesley, J,29427 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Goel, Warren, A,13678 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Ma, Randy, R,24550 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Martin, Janet, L,24540 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Suarez, Shannon, R,12633 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Andersen, Melvin, D,14770 | 6679.59 | 0.00 | 3578.27 | 0.00 | 3101.32 |
| Alvarez, Kathleen, R,17793 | 3250.11 | 0.00 | 0.00 | 2443.35 | 806.76 |
| Alvarez, Cheryl, A,12320 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Kumar, Carly, R,24712 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Subram, Carmen, J,29473 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Xu, Shawn,19328 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Scott, Jason,22557 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-24 06:19:06.361 UTC