[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nath, Terry, E,20148 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Phillips, Gabriella,27631 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Zhang, Rafael, E,23441 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Sanz, Brandi, J,12812 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Ms., Wright, Amanda,26317 | 2862.74 | 0.00 | 0.00 | 2071.42 | 791.32 |
| White, Grace,26735 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Wang, Jorge, M,27829 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mehta, Andre, F,18076 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Shan, Jose,20843 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Hayes, Cameron, D,18431 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Van, Carla, C,19056 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Yang, Jeffery,24225 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Morris, Alexandra,20457 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Murphy, Zoe,11832 | 124.97 | 0.00 | 0.00 | 0.00 | 124.97 |
| Gonzales, Jonathan,28036 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Blue, Mackenzie,12925 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Alexander, Jeremy, D,19239 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Arun, Holly,27154 | 1228.83 | 0.00 | 0.00 | 0.00 | 1228.83 |
| Munoz, Marc, W,27774 | 771.34 | 0.00 | 0.00 | 0.00 | 771.34 |
| James, Nathaniel, C,11867 | 82.93 | 0.00 | 0.00 | 0.00 | 82.93 |
| Jenkins, Jacqueline,23693 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Miller, Ryan, F,25253 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Dominguez, Brandi,27000 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Young, Dalton, R,18954 | 893.47 | 0.00 | 0.00 | 0.00 | 893.47 |
| Wilson, David, M,15908 | 1413.93 | 0.00 | 0.00 | 782.99 | 630.94 |
| Carlson, Reginald,22677 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Ramirez, Faith,29198 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Kumar, Terry, E,20083 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wood, Jocelyn, E,27569 | 4464.48 | 0.00 | 0.00 | 2071.42 | 2393.06 |
| Wright, Gabrielle,24336 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Jenkins, Ryan, C,15971 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wang, Todd,15676 | 7224.68 | 0.00 | 0.00 | 2443.35 | 4781.33 |
| Malhotra, Edgar, K,12555 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Henderson, Jasmine,16801 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Anand, Latoya, D,28347 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Zhang, Rosa, K,14789 | 4382.74 | 0.00 | 3578.27 | 0.00 | 804.47 |
| Russell, Cameron, D,19125 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Taylor, Jose,27201 | 4492.65 | 0.00 | 0.00 | 2049.10 | 2443.55 |
| Smith, Alyssa,26083 | 5794.05 | 0.00 | 3374.99 | 0.00 | 2419.06 |
| Flores, Sarah,23162 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Roberts, Sydney,26080 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Washington, Robert, J,14906 | 45.58 | 0.00 | 0.00 | 0.00 | 45.58 |
| King, Jenna, R,20015 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Garcia, John, M,16432 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Lewis, Samantha, R,14945 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Lu, Louis, K,20356 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Bryant, Riley,26775 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Carlson, Roy, C,20257 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Chapman, Katrina,23897 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Lu, Tamara, E,19072 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Nath, Edwin,24181 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Anand, Colin, G,27645 | 6051.31 | 3578.27 | 0.00 | 0.00 | 2473.04 |
| Martinez, Kaitlin,15750 | 3087.97 | 0.00 | 0.00 | 782.99 | 2304.98 |
| Cook, Dalton, E,18851 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lopez, Bob,15445 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Jiménez, Casey,22438 | 616.95 | 0.00 | 0.00 | 0.00 | 616.95 |
| Simmons, Ryan,25148 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Taylor, Dylan, P,27992 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| King, Kaitlyn,13308 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Lu, Alvin,15417 | 3120.26 | 0.00 | 0.00 | 782.99 | 2337.27 |
| Gonzalez, Jesse, D,22750 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Harris, Nathan, L,13827 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
Generated 2025-12-21 22:25:03.388 UTC