[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 765 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| King, Alex, B,29272 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Lopez, Timothy, O,29273 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Henderson, Alexandra, J,26779 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Hayes, Angelica,26459 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Perez, Nancy, U,19806 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Kelly, Caitlin,14004 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Rubio, Lori,17883 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Martin, Ashley,26116 | 5794.05 | 0.00 | 3374.99 | 0.00 | 2419.06 |
| Hayes, Hunter,26579 | 2840.42 | 0.00 | 0.00 | 2049.10 | 791.32 |
| Sr., Lopez, José, G,25404 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Sai, Toni,18459 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Romero, Beth,20726 | 1941.95 | 0.00 | 0.00 | 782.99 | 1158.96 |
| Mehta, Phillip, H,13844 | 777.44 | 0.00 | 0.00 | 0.00 | 777.44 |
| Chen, Jordan,25854 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Griffin, Dylan,19153 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Yuan, Karl, L,12835 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Destiny,20476 | 2521.31 | 0.00 | 0.00 | 0.00 | 2521.31 |
| Clark, Jasmine, E,25403 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| Suarez, Marvin, M,22443 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ramirez, Brooke, C,11850 | 149.46 | 0.00 | 0.00 | 0.00 | 149.46 |
| Sai, Johnathan, B,24812 | 82.59 | 0.00 | 0.00 | 0.00 | 82.59 |
| Jackson, Wyatt,21579 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Thompson, Anthony,13850 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Chen, Colin, F,16535 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| White, Austin, L,12092 | 51.27 | 0.00 | 0.00 | 0.00 | 51.27 |
| Mitchell, Seth, A,11776 | 6079.24 | 0.00 | 3578.27 | 0.00 | 2500.97 |
| Ramirez, Chloe,26520 | 2827.72 | 0.00 | 0.00 | 2049.10 | 778.62 |
| Rivera, Arianna, R,24973 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Thomas, James, K,19243 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Madan, Andre, C,26946 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Ross, Taylor, S,26545 | 2822.76 | 0.00 | 0.00 | 2071.42 | 751.34 |
| Jones, Thomas, K,25398 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Robinson, Devin,17664 | 624.95 | 0.00 | 0.00 | 0.00 | 624.95 |
| Lu, Marshall, J,22628 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Xu, Cassie,24039 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Raman, Evelyn, W,19310 | 1611.46 | 0.00 | 0.00 | 782.99 | 828.47 |
| Bryant, Faith, L,24992 | 42.84 | 0.00 | 0.00 | 0.00 | 42.84 |
| Ruiz, Randall, A,26171 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Yuan, Brad, S,22162 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Perez, James, L,16385 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Rodriguez, Elizabeth, J,18129 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Hu, Jeffery, E,21132 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Griffin, Caleb,13169 | 191.97 | 0.00 | 0.00 | 0.00 | 191.97 |
| Henderson, Isabel, L,20465 | 2514.93 | 0.00 | 0.00 | 0.00 | 2514.93 |
| Ruiz, Kellie,17159 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Bryant, Jordyn,12766 | 4417.73 | 0.00 | 3578.27 | 0.00 | 839.46 |
| Rai, Marshall, A,25903 | 5773.04 | 0.00 | 3374.99 | 0.00 | 2398.05 |
| Lewis, Jessica, W,25868 | 5798.04 | 0.00 | 3399.99 | 0.00 | 2398.05 |
| Blanco, Kristine, D,25695 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Lin, Cedric, C,13147 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Patterson, Logan,12101 | 92.27 | 0.00 | 0.00 | 0.00 | 92.27 |
| Zhang, Ryan,11873 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Moore, Ryan,26458 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Morgan, Jesse,26007 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Wood, Melissa,26594 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Williams, Tyler,18912 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nara, Misty,14987 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Madan, Jillian, A,13410 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Xu, Bonnie, C,14520 | 1503.58 | 699.10 | 0.00 | 0.00 | 804.48 |
| Anand, Dale, A,29111 | 4389.59 | 0.00 | 3578.27 | 0.00 | 811.32 |
Generated 2025-12-24 06:48:08.973 UTC