[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1093 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Reed, Emma, H,21936 | 99.96 | 0.00 | 0.00 | 0.00 | 99.96 |
| Butler, Edward, L,20655 | 47.42 | 0.00 | 0.00 | 0.00 | 47.42 |
| Cooper, Bailey,17863 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Xie, Tasha, D,24696 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Lopez, Jennifer, D,16998 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Zhou, Shannon, W,14716 | 5300.26 | 0.00 | 0.00 | 2443.35 | 2856.91 |
| Butler, Alexis,26541 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| James, Jared, M,15504 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wang, Sandra,24878 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Baker, Sierra,19465 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Allen, Natalie,16997 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Cox, Natalie,24352 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Moore, Julia,24656 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Nath, Raul,27881 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Young, Jack, L,28078 | 6011.31 | 0.00 | 3578.27 | 0.00 | 2433.04 |
| Murphy, Melanie, L,21297 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Gonzales, Aaron,18804 | 1810.46 | 0.00 | 0.00 | 0.00 | 1810.46 |
| Suarez, Frank,19309 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Watson, Angela, M,22391 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Mitchell, Richard, T,11881 | 148.40 | 0.00 | 0.00 | 0.00 | 148.40 |
| Lopez, Haley, M,26406 | 2334.46 | 0.00 | 0.00 | 0.00 | 2334.46 |
| Romero, Cheryl, A,25786 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Diaz, Connor,21623 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Hernandez, Sheila, S,19832 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Allen, Jordan, L,19835 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Price, Alexis, E,19210 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Johnson, Katherine, C,16062 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gao, Colin,18108 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Sanz, Adrienne,16298 | 7000.87 | 0.00 | 0.00 | 2181.56 | 4819.31 |
| Wilson, Lucas,27622 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Hughes, Marissa,24726 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Torres, Derrick,14691 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Sara, Rachael,25652 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Navarro, Brandi,25535 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Scott, Kevin, R,11648 | 88.99 | 0.00 | 0.00 | 0.00 | 88.99 |
| Bryant, Eric,13471 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| He, Trisha, C,12490 | 167.83 | 0.00 | 0.00 | 0.00 | 167.83 |
| Torres, Shelby, B,17954 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Richardson, Grace, A,17028 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Anderson, Wyatt, M,14284 | 1769.93 | 0.00 | 0.00 | 1000.44 | 769.49 |
| Ruiz, Beth, L,14342 | 1804.92 | 0.00 | 0.00 | 1000.44 | 804.48 |
| Edwards, Natalie,13340 | 4546.52 | 0.00 | 0.00 | 2181.56 | 2364.96 |
| Fernandez, Bob, J,13326 | 4511.55 | 0.00 | 2181.56 | 0.00 | 2329.99 |
| Sánchez, Sergio, S,15670 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Ross, Ana, T,12899 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Perez, Gabrielle,18808 | 2411.94 | 0.00 | 0.00 | 0.00 | 2411.94 |
| Jai, Marshall,15532 | 1589.75 | 0.00 | 0.00 | 782.99 | 806.76 |
| Zhu, Kelvin, R,28666 | 4822.11 | 0.00 | 3578.27 | 0.00 | 1243.84 |
| Phillips, Evan, J,26286 | 3308.17 | 0.00 | 0.00 | 2049.10 | 1259.07 |
| Scott, Jordan, L,15535 | 3099.96 | 0.00 | 0.00 | 782.99 | 2316.97 |
| Saunders, Kristi, A,28684 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Johnson, Austin,11821 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| She, Michele, P,29051 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Martinez, Brandon, S,25352 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Patterson, Riley, S,18058 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hill, Xavier,11258 | 49.23 | 0.00 | 0.00 | 0.00 | 49.23 |
| Lewis, Olivia,24499 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Shan, Ashlee, D,15633 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Lopez, Jackson,13288 | 4573.50 | 0.00 | 0.00 | 2181.56 | 2391.94 |
| Simmons, Melissa, L,24328 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| She, Alan, A,25597 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lopez, Richard, L,25571 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
Generated 2025-12-23 07:19:12.355 UTC