[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ramirez, Anna,17682 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Foster, Alexis,19417 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Morris, Brian, L,24226 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Yang, Jose, C,20329 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Bailey, Nathaniel, S,29336 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Young, Madeline,18121 | 1793.47 | 0.00 | 0.00 | 0.00 | 1793.47 |
| Xu, Carol, P,13580 | 3707.30 | 0.00 | 0.00 | 0.00 | 3707.30 |
| Hall, Sophia,27726 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Sharma, Austin,29204 | 4320.62 | 0.00 | 3578.27 | 0.00 | 742.35 |
| Torres, Bryce, I,21607 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Martinez, Joe,16004 | 2518.25 | 0.00 | 0.00 | 0.00 | 2518.25 |
| Zhang, Luke,18862 | 2354.47 | 0.00 | 0.00 | 0.00 | 2354.47 |
| Perez, Blake, M,11706 | 88.99 | 0.00 | 0.00 | 0.00 | 88.99 |
| Simmons, Jason, M,20396 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Saunders, Roy,15107 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Rogers, Gabrielle,24635 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Martin, Charles, L,24684 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Mehta, Tabitha, I,17134 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Cox, Jessica, B,28816 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Chen, Arturo, V,19352 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Torres, Angel,21290 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Murphy, Riley, J,23712 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Baker, Evan, E,19893 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Gill, Robin, J,12477 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Campbell, Kaitlyn,21004 | 561.48 | 0.00 | 0.00 | 561.48 | 0.00 |
| Adams, Eric,24777 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Lopez, Troy, M,19427 | 1967.45 | 0.00 | 0.00 | 782.99 | 1184.46 |
| Stewart, Savannah, K,16947 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Rodriguez, Hunter, P,11307 | 5964.22 | 0.00 | 3578.27 | 0.00 | 2385.95 |
| Liu, Laura,19998 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
Generated 2025-12-21 15:25:06.775 UTC