[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Hernandez, Kristy, G,18813 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Stewart, Christina, R,25296 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Long, Mariah, C,16730 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Washington, Arianna, C,28009 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Shen, Sheena,21771 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Murphy, Sebastian, R,13876 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Coleman, Morgan,23956 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Nara, Carl, K,12971 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Price, Anna,14576 | 1476.54 | 699.10 | 0.00 | 0.00 | 777.44 |
| Gutierrez, Leslie,25758 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Stewart, Patrick, L,11882 | 47.94 | 0.00 | 0.00 | 39.99 | 7.95 |
| Rogers, Chase,27648 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Raje, Nina, R,25137 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Morris, Catherine,11188 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Arun, Darren,29219 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Jackson, Brianna,15377 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Diaz, Stephanie,15694 | 100.09 | 0.00 | 0.00 | 0.00 | 100.09 |
| Richardson, Erin, R,16331 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Shen, Raul,19507 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Thompson, Ryan, M,11330 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Flores, Carson, J,25375 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Carter, Alex, M,12042 | 5975.23 | 0.00 | 3578.27 | 0.00 | 2396.96 |
| Gonzales, Olivia, A,24201 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| McDonald, Brianna,25943 | 5808.03 | 0.00 | 3374.99 | 0.00 | 2433.04 |
| Washington, Melissa,12191 | 245.47 | 0.00 | 0.00 | 125.47 | 120.00 |
| Lewis, Dalton,16776 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Howard, Katelyn, L,19174 | 2483.98 | 0.00 | 782.99 | 0.00 | 1700.99 |
| Browning, Theodore, L,16540 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Vazquez, Jill,15664 | 2770.52 | 0.00 | 2181.56 | 0.00 | 588.96 |
| Hayes, Connor,27626 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Foster, Cassidy,20488 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
Generated 2024-09-20 17:23:35.339 UTC