[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 65 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Blanco, Beth,29444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 0.00 | 782.99 | 2638.94 |
| Sanz, Pedro,18168 | 6907.55 | 0.00 | 0.00 | 2181.56 | 4725.99 |
| Raji, Jenny,21870 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Rai, Casey, M,19308 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Foster, Jordan, M,20807 | 3249.31 | 0.00 | 0.00 | 782.99 | 2466.32 |
| Carlson, Diane, W,21074 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Goel, Johnny, J,22569 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Reed, Taylor,23983 | 1195.47 | 0.00 | 0.00 | 0.00 | 1195.47 |
| Patel, Rebekah, R,22396 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Young, Evan,12739 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Ramos, Daisy,14552 | 103.97 | 0.00 | 0.00 | 0.00 | 103.97 |
| Ramos, Teresa,13689 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Rodriguez, Stefanie, L,12459 | 5618.54 | 0.00 | 0.00 | 2071.42 | 3547.12 |
| Zhu, Lisa, R,15059 | 6793.54 | 0.00 | 3578.27 | 0.00 | 3215.27 |
| Nara, Gilbert, O,28425 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Huang, Colin,20712 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Chandra, Mayra,16453 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| McDonald, George,11394 | 8161.97 | 0.00 | 3399.99 | 2342.92 | 2419.06 |
| Zhou, Rosa, D,25573 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gill, Alfredo, M,23629 | 2466.32 | 0.00 | 0.00 | 2466.32 | 0.00 |
| Butler, Kayla, J,25748 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Nara, Louis, J,26901 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Nara, Terry,27305 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Sai, Veronica,16509 | 3258.79 | 0.00 | 0.00 | 2443.35 | 815.44 |
| Prasad, Cassandra, D,18621 | 3033.33 | 0.00 | 0.00 | 2443.35 | 589.98 |
| Taylor, Michael,27907 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
Generated 2025-12-22 02:14:09.927 UTC