[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 15 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Kaitlin, J,25807 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Lee, Olivia, A,20684 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Blanco, Kellie, M,25232 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Raje, Katie,14178 | 86.58 | 0.00 | 0.00 | 0.00 | 86.58 |
| Rai, Kenneth, S,13207 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Fernandez, Levi,15654 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Xu, Kurt, S,16422 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Hernandez, Daisy,25307 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Perez, Denise, W,14954 | 70.95 | 0.00 | 0.00 | 0.00 | 70.95 |
| Fernandez, Brett, L,16214 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Jenkins, Edward, S,28725 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Cooper, Sara,18050 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Sara, Heidi, T,19472 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Hu, Kelvin,12825 | 4419.06 | 0.00 | 0.00 | 2049.10 | 2369.96 |
| Flores, Angela, B,20028 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Ward, Christina, H,12979 | 180.98 | 0.00 | 0.00 | 0.00 | 180.98 |
| Russell, Blake, A,20657 | 1193.45 | 0.00 | 0.00 | 0.00 | 1193.45 |
| Patterson, Sarah, G,21772 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Adams, Jesse, M,17172 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Wilson, Richard,23520 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Perez, Adriana, K,14762 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wilson, David, M,15908 | 1413.93 | 0.00 | 0.00 | 782.99 | 630.94 |
| Hughes, Haley, M,23127 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Romero, Andy, K,28750 | 3213.57 | 0.00 | 0.00 | 2049.10 | 1164.47 |
| Kelly, Morgan, L,14761 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Morgan, Grace, E,25601 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| She, Cassie,21031 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Cox, Andrea,13830 | 195.59 | 0.00 | 0.00 | 0.00 | 195.59 |
Generated 2025-12-21 20:27:03.228 UTC