[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 938 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Taylor, Wyatt,27295 | 4442.16 | 0.00 | 0.00 | 2049.10 | 2393.06 |
| Perez, Ian, L,17469 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chande, Omar, M,27261 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Rubio, Julio,17945 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Gill, Michele, M,17834 | 4158.72 | 0.00 | 0.00 | 1000.44 | 3158.28 |
| Butler, David, H,16138 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Martinez, Samantha, C,12742 | 5148.31 | 0.00 | 0.00 | 4466.39 | 681.92 |
| Ross, Abigail, I,27450 | 4514.97 | 0.00 | 0.00 | 2071.42 | 2443.55 |
| Jenkins, Ethan, F,27431 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Patel, Johnathan,19289 | 2765.40 | 0.00 | 0.00 | 1000.44 | 1764.96 |
| Wilson, David, M,15908 | 1413.93 | 0.00 | 0.00 | 782.99 | 630.94 |
| Powell, Aidan,27275 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Perry, Vanessa,18224 | 2394.45 | 0.00 | 0.00 | 0.00 | 2394.45 |
| Cai, Alejandro, J,13938 | 3071.01 | 0.00 | 0.00 | 2181.56 | 889.45 |
| Jenkins, Paige, M,18225 | 2349.96 | 0.00 | 0.00 | 0.00 | 2349.96 |
| Richardson, Amanda,15888 | 3178.95 | 0.00 | 0.00 | 782.99 | 2395.96 |
| Russell, Jose, J,23292 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Cook, Cole, W,23197 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Xu, Katrina, B,24668 | 2473.04 | 0.00 | 0.00 | 0.00 | 2473.04 |
| Johnson, Hunter, M,27549 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Collins, Natalie,17963 | 3932.54 | 0.00 | 0.00 | 2181.56 | 1750.98 |
| Nelson, Marcus, N,19903 | 3177.94 | 0.00 | 0.00 | 782.99 | 2394.95 |
| Huang, Trisha,11578 | 4406.39 | 0.00 | 0.00 | 2071.42 | 2334.97 |
| Mehta, Candace,11588 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Miller, Jonathan, A,25356 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Diaz, Erika, F,11590 | 4384.07 | 0.00 | 0.00 | 2049.10 | 2334.97 |
| Hill, Kevin, C,27547 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Sun, Tiffany, P,17989 | 3932.54 | 0.00 | 0.00 | 2181.56 | 1750.98 |
| Henderson, Julia, L,23300 | 133.47 | 0.00 | 0.00 | 0.00 | 133.47 |
| Xie, Shawn, J,16476 | 4715.49 | 0.00 | 0.00 | 2181.56 | 2533.93 |
| Henderson, Ethan,16436 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
Generated 2025-12-22 02:33:21.286 UTC