[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 50 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sharma, Nicolas, D,13517 | 5666.38 | 0.00 | 0.00 | 2049.10 | 3617.28 |
| Cook, Jade, C,25687 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Bryant, Marissa, A,28892 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Ortega, Larry, C,18126 | 6945.58 | 0.00 | 0.00 | 2181.56 | 4764.02 |
| Randall, Mayra,27909 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Martin, Dalton, J,12505 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Martin, Sabrina, D,25578 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Carlson, Derrick, R,28436 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Howard, Victoria, L,21525 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Lopez, Cassandra,22308 | 1768.96 | 0.00 | 0.00 | 0.00 | 1768.96 |
| Gill, Cheryl, R,28410 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Taylor, Grace,24073 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Martin, Billy, B,26849 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Foster, Mary,24112 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Malhotra, Troy,11569 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Martin, Michele, J,27819 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Blanco, Beth,29444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Deng, Karla, C,29382 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Perez, Manuel, C,13777 | 7147.07 | 0.00 | 3578.27 | 0.00 | 3568.80 |
| Carlson, Lee, S,21079 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Wood, Julian, A,18166 | 7200.37 | 0.00 | 0.00 | 2443.35 | 4757.02 |
| Browning, Carrie, G,19299 | 1587.41 | 0.00 | 0.00 | 1000.44 | 586.97 |
| Munoz, Daisy,15081 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Lopez, Allen, O,13821 | 5940.54 | 0.00 | 3578.27 | 0.00 | 2362.27 |
| Gonzalez, Evelyn, L,12859 | 5666.22 | 0.00 | 0.00 | 2071.42 | 3594.80 |
Generated 2025-12-21 18:07:34.125 UTC