[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lal, Kelli, J,19173 | 1594.42 | 0.00 | 1000.44 | 0.00 | 593.98 |
| Malhotra, Frederick,17951 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Martin, Ross,16201 | 3058.01 | 0.00 | 2181.56 | 0.00 | 876.45 |
| Deng, Nichole,19933 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ruiz, Audrey,12645 | 6847.76 | 0.00 | 0.00 | 2071.42 | 4776.34 |
| Beck, Bradley, L,22388 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Gomez, Joy, J,12658 | 6863.44 | 0.00 | 0.00 | 2071.42 | 4792.02 |
| Wu, Heather, M,19261 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Rubio, Jill,13838 | 140.55 | 0.00 | 0.00 | 0.00 | 140.55 |
| Hu, Tiffany, A,20856 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Chandra, Sergio, A,22837 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Hernandez, Gerald, L,24054 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Ramos, Diana, J,28733 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Vance, Ebony,20724 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sharma, Cassie, A,26978 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Kelly, Richard,17991 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Shan, Cristina,14783 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Lal, Jerry, L,27822 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Diaz, Stephanie,15694 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Madan, Dominic, F,21847 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Tang, Colleen, A,25731 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Deng, Sharon, A,26893 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Alvarez, Erika,15615 | 70.24 | 0.00 | 0.00 | 0.00 | 70.24 |
| Torres, Juan, M,12746 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Kapoor, Jillian, R,15701 | 78.86 | 0.00 | 0.00 | 0.00 | 78.86 |
| Kumar, Corey,15354 | 8297.29 | 0.00 | 3578.27 | 0.00 | 4719.02 |
| Arun, Rachael, J,23976 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Reed, Rachel, E,12644 | 6838.12 | 0.00 | 0.00 | 2049.10 | 4789.02 |
| Jackson, Lucas, A,25481 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
Generated 2025-12-23 03:59:55.497 UTC