[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1218 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Rodriguez, Martin,19678 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Ma, Ramon, D,27526 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 | 0.00 |
| Moore, Madison,23327 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 | 0.00 |
| Munoz, Erik, E,14715 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 | 0.00 |
| Ma, Nuan,21007 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 | 0.00 |
| Rubio, Ricky,24562 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 | 0.00 |
| Butler, Jeremy,11236 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 | 0.00 |
| Patterson, Brittany, M,12982 | 57.97 | 0.00 | 0.00 | 0.00 | 57.97 | 0.00 |
| Green, Miguel, A,29274 | 4479.62 | 0.00 | 3578.27 | 0.00 | 901.35 | 0.00 |
| Bailey, Chase, E,24801 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Luo, Misty, R,19067 | 3380.91 | 0.00 | 0.00 | 1000.44 | 2380.47 | 0.00 |
| Collins, Aaron, P,27663 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 | 0.00 |
| Adams, Blake, L,18646 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 | 0.00 |
| Rai, Latoya, A,20883 | 1149.47 | 0.00 | 0.00 | 0.00 | 1149.47 | 0.00 |
| Griffin, Abigail, A,19256 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 | 0.00 |
| Lal, Bethany, A,16253 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 | 0.00 |
| Li, Dennis,14837 | 116.95 | 0.00 | 0.00 | 0.00 | 116.95 | 0.00 |
| Sanchez, Johnathan,24411 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 | 0.00 |
| Rivera, Catherine,18064 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 | 0.00 |
| Rivera, Taylor, C,17519 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 | 0.00 |
| Griffin, Edward,13430 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 | 0.00 |
| Chen, Kyle,13166 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 | 0.00 |
| Ross, Edward,22368 | 615.47 | 0.00 | 0.00 | 0.00 | 615.47 | 0.00 |
| Lopez, Roy, I,26987 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Kumar, Kara,26046 | 93.48 | 0.00 | 0.00 | 0.00 | 93.48 | 0.00 |
| Cox, Adrian, J,20443 | 39.47 | 0.00 | 0.00 | 0.00 | 39.47 | 0.00 |
| Foster, Jacqueline, K,20020 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 | 0.00 |
| Bailey, Megan, C,15292 | 54.96 | 0.00 | 0.00 | 0.00 | 54.96 | 0.00 |
| Jones, Joseph,13921 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 | 0.00 |
| Anderson, Sydney,16145 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 | 0.00 |
| Liang, Willie, M,19484 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 | 0.00 |
| Adams, Morgan,12663 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Simmons, Hunter,16981 | 2317.92 | 0.00 | 0.00 | 0.00 | 2317.92 | 0.00 |
| Hughes, Gabrielle,23724 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 | 0.00 |
| Wang, Ryan, D,23454 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 | 0.00 |
| Diaz, Brandi,16424 | 5738.38 | 0.00 | 0.00 | 2181.56 | 3556.82 | 0.00 |
| Alvarez, Michele, J,11844 | 124.97 | 0.00 | 0.00 | 0.00 | 124.97 | 0.00 |
| Lopez, Amanda, J,24448 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 | 0.00 |
| Zhu, Micah, V,11576 | 4486.41 | 0.00 | 0.00 | 2071.42 | 2414.99 | 0.00 |
| Zhang, Cameron, F,21633 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 | 0.00 |
| Lee, Alexandra,19684 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 | 0.00 |
| Jenkins, Melanie,17138 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 | 0.00 |
| Martinez, Raymond,15352 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Chander, Corey, A,24708 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Nara, Bridget, L,12846 | 4460.38 | 0.00 | 0.00 | 2071.42 | 2388.96 | 0.00 |
| Suarez, Lee, D,22680 | 620.95 | 0.00 | 0.00 | 0.00 | 620.95 | 0.00 |
| Sanz, Miguel, J,27381 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Stewart, Isabella, M,20742 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 | 0.00 |
| Wilson, Thomas, E,15573 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Navarro, Joan,19180 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Nath, Kelli,24715 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 | 0.00 |
| Malhotra, Martin,12651 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 | 0.00 |
| Green, Allison,16111 | 2340.94 | 0.00 | 0.00 | 0.00 | 2340.94 | 0.00 |
| Powell, Isabella, L,20923 | 2374.80 | 0.00 | 0.00 | 782.99 | 1591.81 | 0.00 |
| Roberts, Alex, K,18553 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 | 0.00 |
| Sai, Deanna, D,18008 | 2459.07 | 0.00 | 699.10 | 0.00 | 1759.97 | 0.00 |
| Rubio, Neil,20953 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 | 0.00 |
| Dominguez, Joe, A,28461 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 | 0.00 |
| Thompson, Sarah,12423 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 | 0.00 |
| Martin, Dylan,17002 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 | 0.00 |
| Mitchell, Gabriella, L,17013 | 2401.45 | 0.00 | 0.00 | 0.00 | 2401.45 | 0.00 |
| Walker, Devin, P,26634 | 2896.72 | 0.00 | 0.00 | 2071.42 | 825.30 | 0.00 |
Generated 2026-01-04 05:38:25.666 UTC