[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 33 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Reed, Alexa, C,23685 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Brooks, Nicole,26467 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Moore, Brandon, T,29218 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Adams, Jackson, H,17449 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhou, Erica, M,19062 | 79.95 | 0.00 | 0.00 | 0.00 | 79.95 |
| Raji, Kristin,14297 | 3335.42 | 0.00 | 0.00 | 1000.44 | 2334.98 |
| Vance, Kari, C,21531 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Rai, Connie,16044 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Dominguez, Anne,13258 | 5308.26 | 0.00 | 0.00 | 0.00 | 5308.26 |
| Baker, Marcus,17520 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Johnson, Christian, S,26082 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 |
| Jones, Christian, S,18423 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| King, Jennifer, C,20762 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Sharma, April, J,17997 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zhou, Kristen, R,23632 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Rivera, Catherine,18064 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Lee, Katherine, A,29226 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Morgan, Riley, R,26530 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| King, Jonathan, C,25202 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Mehta, Phillip, H,13844 | 777.44 | 0.00 | 0.00 | 0.00 | 777.44 |
| Ortega, Diana,12125 | 8595.41 | 0.00 | 0.00 | 2071.42 | 6523.99 |
| Parker, Sydney,20512 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Suri, Bryant, E,18152 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Collins, Luke, A,20633 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
Generated 2025-12-24 06:03:57.569 UTC