[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 77 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nath, Jenny,27281 | 4540.47 | 0.00 | 0.00 | 2071.42 | 2469.05 |
| Zhao, Todd,23991 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Kapoor, Francisco, M,16063 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hernandez, Tabitha, L,19603 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Simpson, Mindy, A,15200 | 3142.97 | 0.00 | 0.00 | 782.99 | 2359.98 |
| Thompson, Ashley,15104 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Miller, Tyler, E,11940 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Garcia, Nathan, W,14085 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Wang, Suzanne, R,29141 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Anderson, Joshua, A,20507 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Foster, Logan, F,21302 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Henderson, Luis,14579 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Lu, Amy, A,20464 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Madan, Pamela,18502 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Lee, Taylor,14022 | 1668.90 | 0.00 | 0.00 | 1000.44 | 668.46 |
| Gonzales, Taylor, M,21590 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Russell, Blake, A,20657 | 1193.45 | 0.00 | 0.00 | 0.00 | 1193.45 |
| Diaz, Miguel, A,21149 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Yuan, Michele, L,22331 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Thompson, Dalton, Y,13028 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| James, Hailey, C,25970 | 4603.82 | 0.00 | 3374.99 | 0.00 | 1228.83 |
| Goel, Kristin, L,25473 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| She, April,19196 | 4657.74 | 0.00 | 0.00 | 1000.44 | 3657.30 |
| Parker, Chloe, J,27480 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Shan, Ricardo,24210 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Ross, Hannah, C,18472 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Fernandez, Terrance, G,29438 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Jackson, Brianna,15377 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Martin, Blake,21782 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Wang, Eric,14409 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
Generated 2025-12-22 06:12:23.513 UTC