[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 < SKIP 250 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzales, Jocelyn,29212 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Blue, Sara,17118 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Robinson, Nathan, T,15380 | 3145.26 | 0.00 | 0.00 | 782.99 | 2362.27 |
| Ruiz, Brandi,12221 | 2389.98 | 0.00 | 0.00 | 0.00 | 2389.98 |
| Carter, Greg, G,15348 | 3198.45 | 0.00 | 0.00 | 782.99 | 2415.46 |
| Wilson, Lauren, A,14887 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Chande, Bradley, R,29450 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Harris, Dylan, L,28648 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Zhu, Kelvin, R,28666 | 4822.11 | 0.00 | 3578.27 | 0.00 | 1243.84 |
| Martin, Devin, P,11181 | 41.28 | 0.00 | 0.00 | 0.00 | 41.28 |
| Zhou, Kristen, R,23632 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Reed, Gloria,28228 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Xie, Damien,20553 | 2354.98 | 0.00 | 0.00 | 0.00 | 2354.98 |
| Jimenez, Philip, B,19837 | 589.98 | 0.00 | 0.00 | 0.00 | 589.98 |
| Henderson, Sydney,20400 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Peterson, Riley, S,22025 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Sanz, Javier, E,19932 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Chapman, Katrina,23897 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| White, Marcus,20066 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Sun, Ernest, V,22868 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Martin, Rachel, S,13269 | 4507.52 | 0.00 | 0.00 | 2181.56 | 2325.96 |
| Cooper, Natalie, A,29033 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Vance, Marco,13124 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Lee, Miguel,12749 | 5915.54 | 0.00 | 3578.27 | 0.00 | 2337.27 |
| Chen, Jorge, T,20442 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 |
| Hughes, Jose,26175 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Rogers, Lucas,25085 | 1228.83 | 0.00 | 0.00 | 1228.83 | 0.00 |
| Nath, Misty, E,24141 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Hayes, Blake, G,16778 | 2541.32 | 0.00 | 0.00 | 0.00 | 2541.32 |
| Zhao, Jeffery,17931 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Xie, Ashlee, S,26943 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Bennett, Olivia, D,28067 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| James, Mackenzie, L,27056 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Long, Dakota, N,22453 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Carolyn, B,26228 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Williams, Marcus, B,22298 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Hall, Jan, M,11740 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Wang, Gabriel,11163 | 46.27 | 0.00 | 0.00 | 0.00 | 46.27 |
| Ma, Nuan,21007 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Serrano, Gary, G,21021 | 628.97 | 0.00 | 0.00 | 628.97 | 0.00 |
| Perry, Thomas, R,18867 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Wood, Jennifer, L,26274 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Hayes, Adam,24028 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Dominguez, Linda,20051 | 4464.27 | 0.00 | 0.00 | 782.99 | 3681.28 |
| Ward, Gabriella,18229 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Morris, Chloe, D,14621 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Huang, Laura, P,18185 | 3332.39 | 0.00 | 0.00 | 1000.44 | 2331.95 |
| Long, Caroline,29151 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Kelly, Jade,27068 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Morgan, Rachel,27463 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Richardson, Carlos,22190 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Alonso, Walter, C,18138 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Subram, Marco, C,28174 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhao, Roger,22322 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Watson, Olivia, S,13860 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Hayes, Richard,17177 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Brown, Alyssa, O,26468 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Martinez, Xavier,12063 | 84.99 | 0.00 | 0.00 | 0.00 | 84.99 |
| Shen, Johnny,19330 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Martinez, Kristi, L,21529 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Gonzalez, Gabriel, R,14471 | 3355.43 | 0.00 | 0.00 | 1000.44 | 2354.99 |
| Lopez, Alexandra,14088 | 2755.42 | 0.00 | 0.00 | 1000.44 | 1754.98 |
Generated 2025-12-23 14:10:17.297 UTC