[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 77 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gill, Natasha, A,20388 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Collins, Samuel,11634 | 39.58 | 0.00 | 0.00 | 0.00 | 39.58 |
| James, Makayla, E,29258 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Sanchez, Zoe, S,14396 | 76.96 | 0.00 | 0.00 | 0.00 | 76.96 |
| Wood, Marissa,14386 | 1918.40 | 0.00 | 0.00 | 1000.44 | 917.96 |
| Robinson, Ethan, J,18034 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Rodriguez, Preston,13849 | 3084.54 | 0.00 | 0.00 | 3084.54 | 0.00 |
| Ruiz, Meghan, A,15629 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Peterson, Adrian, J,21236 | 77.92 | 0.00 | 0.00 | 0.00 | 77.92 |
| Mehta, Andre, F,18076 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Prasad, Andre,27307 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Kapoor, Tabitha, M,25729 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Cook, Mackenzie, R,14589 | 1468.59 | 0.00 | 699.10 | 0.00 | 769.49 |
| Sanders, Caitlin,29233 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Cai, Brittney, L,25898 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Cox, Emma, R,27249 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Shan, Tara, C,22447 | 793.76 | 0.00 | 0.00 | 0.00 | 793.76 |
| Stewart, Riley, L,18420 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Mehta, Jillian, H,21834 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Flores, María,17359 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wright, Caleb,15843 | 3142.97 | 0.00 | 0.00 | 782.99 | 2359.98 |
| Washington, Gabriel,24814 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Li, Arturo,27844 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Bryant, Jordan, K,18645 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Fernandez, Raymond,23004 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Rodriguez, Jennifer, T,27067 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Torres, Erik, J,14919 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rogers, Natalie, A,14577 | 1505.86 | 0.00 | 699.10 | 0.00 | 806.76 |
Generated 2025-12-24 06:06:56.281 UTC