[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Jackson, Benjamin, J,13570 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 | 0.00 |
| Hughes, Christian, J,11522 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 | 0.00 |
| Roberts, Jason, G,18970 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 | 0.00 |
| Zhou, Roger, L,23950 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 | 0.00 |
| Zheng, Margaret, D,13823 | 5393.31 | 0.00 | 0.00 | 2443.35 | 2949.96 | 0.00 |
| Collins, Elijah, L,18824 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 | 0.00 |
| Kumar, Brandon, A,12790 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 | 0.00 |
| Morgan, Erin,26067 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 | 0.00 |
| Watson, Arianna, A,19009 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 | 0.00 |
| Munoz, Carrie, R,20601 | 80.47 | 0.00 | 0.00 | 0.00 | 0.00 | 80.47 |
| Nelson, Amanda,12788 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 | 0.00 |
| Hall, Chloe, E,18551 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 | 0.00 |
| Muñoz, Javier,26385 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 | 0.00 |
| Mehta, Jermaine, E,19803 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 | 0.00 |
| Coleman, Taylor,18104 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 | 0.00 |
| Watson, Gabrielle, A,21696 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Ramirez, Arianna, C,22897 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 | 0.00 |
| Jackson, Marcus,23835 | 603.96 | 0.00 | 0.00 | 0.00 | 603.96 | 0.00 |
| Lal, Jon, M,22342 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Winston, Samuel, L,27539 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 | 0.00 |
| Clark, Noah,18223 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Miller, Daniel, V,27193 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 | 0.00 |
| Hernandez, Diane, P,21015 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 | 0.00 |
| Griffin, Alexandria,26464 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 | 0.00 |
| Ward, Alyssa, M,19268 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 | 0.00 |
| Suri, Sergio, C,16391 | 4624.91 | 0.00 | 0.00 | 4624.91 | 0.00 | 0.00 |
| Watson, Seth, I,26720 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Torres, Alex, L,18512 | 2349.98 | 0.00 | 0.00 | 0.00 | 2349.98 | 0.00 |
| Brooks, Alex,14251 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 | 0.00 |
| Simmons, Ashley, R,26898 | 173.95 | 0.00 | 0.00 | 0.00 | 173.95 | 0.00 |
| Martin, Samantha,27541 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 | 0.00 |
| Russell, Spencer,11302 | 5938.19 | 0.00 | 3578.27 | 0.00 | 2359.92 | 0.00 |
| Murphy, Patrick, M,14334 | 1848.91 | 0.00 | 0.00 | 1000.44 | 848.47 | 0.00 |
| Perry, Xavier, L,23387 | 93.96 | 0.00 | 0.00 | 0.00 | 93.96 | 0.00 |
| Gonzalez, Denise, P,27886 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Barnes, Seth,21603 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 | 0.00 |
| Lopez, Amber,29208 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Patel, Edgar, M,16880 | 2343.96 | 0.00 | 0.00 | 0.00 | 2343.96 | 0.00 |
| Carlson, Jessie,15683 | 89.98 | 0.00 | 0.00 | 0.00 | 89.98 | 0.00 |
| Patterson, Madison,17779 | 4250.21 | 0.00 | 0.00 | 1000.44 | 3249.77 | 0.00 |
| Baker, Blake,25368 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 | 0.00 |
| Nath, Maurice,14092 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 | 0.00 |
| Phillips, Eric, W,19712 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 | 0.00 |
| Alexander, Devin,24402 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 | 0.00 |
| Cook, Savannah, E,21442 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 | 0.00 |
| Carlson, Carolyn, S,23828 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 | 0.00 |
| Carlson, Walter,19943 | 3112.97 | 0.00 | 0.00 | 782.99 | 2329.98 | 0.00 |
| Randall, Tammy, C,13798 | 100.09 | 0.00 | 0.00 | 0.00 | 100.09 | 0.00 |
| Mitchell, Devin,26819 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 | 0.00 |
| Long, Tristan,27566 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 | 0.00 |
| Raman, Kristi,21836 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Chandra, Ruth,16208 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 | 0.00 |
| Deng, Katie,16194 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 | 0.00 |
| Jones, Victoria, S,13450 | 4773.33 | 0.00 | 0.00 | 2443.35 | 2329.98 | 0.00 |
| Cook, Mackenzie, R,14589 | 1468.59 | 0.00 | 699.10 | 0.00 | 769.49 | 0.00 |
| Perez, Jarrod, C,19651 | 59.25 | 0.00 | 0.00 | 0.00 | 59.25 | 0.00 |
| Vazquez, Audrey,14850 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Hu, Arturo, R,14663 | 104.95 | 0.00 | 0.00 | 0.00 | 104.95 | 0.00 |
| Wood, Eduardo, E,29138 | 4374.61 | 0.00 | 3578.27 | 0.00 | 796.34 | 0.00 |
| Stewart, Brian,19426 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 | 0.00 |
Generated 2026-01-04 05:29:37.261 UTC