[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 76 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Turner, Charles,24188 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| King, Thomas, M,29433 | 1289.33 | 0.00 | 0.00 | 0.00 | 1289.33 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Gill, Briana, D,12654 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Subram, Meagan, W,11573 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Bell, Sebastian, D,27785 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Taylor, Charles,13792 | 7216.08 | 0.00 | 3578.27 | 0.00 | 3637.81 |
| Chen, Gilbert, E,27906 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Luo, Kara,28903 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Nath, Leonard, L,12637 | 6845.12 | 0.00 | 0.00 | 2049.10 | 4796.02 |
| James, Arianna, A,25799 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Xie, Louis, B,13590 | 8306.30 | 3578.27 | 0.00 | 0.00 | 4728.03 |
| Navarro, Walter, S,17841 | 2803.52 | 0.00 | 0.00 | 2181.56 | 621.96 |
| Henderson, Marissa,13816 | 260.83 | 0.00 | 0.00 | 0.00 | 260.83 |
| Srini, Francisco, H,12602 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Perez, Clifford, R,15690 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shen, Damien, C,14964 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Shan, Willie,17098 | 2768.53 | 0.00 | 0.00 | 2768.53 | 0.00 |
| Carlson, Jamie,23770 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Luo, Gregory,17642 | 32.95 | 0.00 | 0.00 | 0.00 | 32.95 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Madan, Douglas,26971 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Jones, Andrew, C,16594 | 7231.37 | 0.00 | 0.00 | 2443.35 | 4788.02 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 0.00 | 325.83 |
| Martin, Teresa, D,22588 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Ramos, Cheryl, A,25682 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Lal, Wayne, C,16829 | 7185.37 | 0.00 | 0.00 | 2443.35 | 4742.02 |
| Suarez, Felicia, W,28703 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Howard, Jennifer,16264 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Shan, Jerry,19382 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
Generated 2025-12-23 07:08:53.602 UTC