[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 71 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Travers, Shirleen, H,28265 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramos, Reginald,12813 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Price, Fernando,28127 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ma, Aimee, R,21868 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Srini, Johnathan,14097 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Perez, Thomas,17466 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Stewart, Olivia, B,18749 | 181.03 | 0.00 | 0.00 | 0.00 | 181.03 |
| Brown, Joshua,20695 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Patterson, Alexandra, A,19489 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ruiz, Diane, F,14818 | 2973.98 | 0.00 | 0.00 | 2181.56 | 792.42 |
| Mr., Seely, Scott,16603 | 7000.55 | 0.00 | 0.00 | 2181.56 | 4818.99 |
| Harris, Madison, K,21728 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Hill, Mary, M,25622 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Anand, Omar,19375 | 120.46 | 0.00 | 0.00 | 0.00 | 120.46 |
| Washington, Tristan, A,22341 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Wu, Wesley, R,14205 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Johnson, Jessica,13063 | 4773.33 | 0.00 | 2443.35 | 0.00 | 2329.98 |
| James, Caitlin, V,15503 | 1622.45 | 0.00 | 0.00 | 782.99 | 839.46 |
| Henderson, Aidan,28171 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Johnson, Alexandra, J,27435 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Lopez, Erick, A,16567 | 7159.70 | 0.00 | 0.00 | 2443.35 | 4716.35 |
| Chande, Mario, P,23256 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Ashe, Reginald,28706 | 773.63 | 0.00 | 0.00 | 0.00 | 773.63 |
| Powell, James, V,28231 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Richardson, Xavier,11700 | 137.96 | 0.00 | 0.00 | 62.98 | 74.98 |
| Shen, Andres,20045 | 596.96 | 0.00 | 0.00 | 0.00 | 596.96 |
| Anand, Shaun,25524 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Li, Valerie, R,27507 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
Generated 2025-12-23 11:55:07.766 UTC