[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 92 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Torres, Diana, M,17685 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Richardson, Sara,11312 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Wright, Edward,22744 | 54.21 | 0.00 | 0.00 | 0.00 | 54.21 |
| Garcia, Eduardo, D,24291 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Hernandez, Gabriella,16375 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Hayes, Miranda, D,27447 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Thomas, Nicole,11795 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Powell, Madison, S,24735 | 2478.04 | 0.00 | 0.00 | 0.00 | 2478.04 |
| Sanders, Savannah, J,14892 | 1468.59 | 0.00 | 699.10 | 0.00 | 769.49 |
| West, Isabella,19238 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Flores, Jasmine,20540 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Madan, Ruth,12237 | 4470.39 | 0.00 | 0.00 | 2071.42 | 2398.97 |
| Gray, Chase, J,15688 | 6221.52 | 0.00 | 0.00 | 2181.56 | 4039.96 |
| Sai, Douglas, A,20833 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Hernandez, Jaime,29166 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 |
| Phillips, Elijah,28835 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Davis, Joseph, E,13352 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Griffin, Alexia, W,18027 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Carter, Seth, A,20126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Simmons, Aaron,13891 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Wood, Miranda,15854 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Patterson, Angela,21619 | 556.26 | 0.00 | 0.00 | 0.00 | 556.26 |
| Clark, Jennifer,25881 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Thompson, Hannah, C,26262 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Perry, Angela,11623 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Hernandez, Miguel, L,24239 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Cox, Stephanie, R,12366 | 88.96 | 0.00 | 0.00 | 0.00 | 88.96 |
| Jackson, Megan,12794 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
Generated 2025-12-23 11:38:13.831 UTC