[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Davis, Anthony, S,13188 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Cox, Paige,24673 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Clark, Eduardo,28240 | 5998.61 | 0.00 | 3578.27 | 0.00 | 2420.34 |
| Zheng, Nuan,13604 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Kelly, Kaylee, W,14602 | 3150.54 | 0.00 | 699.10 | 0.00 | 2451.44 |
| Young, Andrea,22092 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Miller, Brandon, L,17357 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vazquez, Erik, A,24124 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Perez, Jason,25338 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Rogers, Jasmine, K,23243 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Harris, Brandon,24517 | 86.58 | 0.00 | 0.00 | 0.00 | 86.58 |
| Liang, Stacey,16538 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Patterson, Miranda,22749 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Anderson, Christian,16503 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| James, Jennifer, D,29164 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Jackson, Julia, E,22067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Zheng, Brittney, B,27913 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Griffin, Amanda, A,15379 | 3184.44 | 0.00 | 0.00 | 782.99 | 2401.45 |
| Coleman, Aidan, L,20077 | 633.45 | 0.00 | 0.00 | 0.00 | 633.45 |
| Coleman, Gavin,24527 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Lee, Jose, E,20078 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Ware, Victoria,13937 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Wright, Caleb,15843 | 3142.97 | 0.00 | 0.00 | 782.99 | 2359.98 |
| Robinson, Dylan, L,14724 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| James, Ariana,23282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Martinez, Brianna, H,22747 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Yang, Krystal,22344 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Griffin, Nathan,16147 | 2367.20 | 0.00 | 0.00 | 0.00 | 2367.20 |
| Rodriguez, Justin, J,11838 | 135.21 | 0.00 | 0.00 | 0.00 | 135.21 |
| Nara, Kathryn, E,14882 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Navarro, Ross,22435 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Evans, Sydney,19204 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Chen, Kyle,13166 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Martinez, Richard, J,14986 | 47.94 | 0.00 | 0.00 | 0.00 | 47.94 |
| Peterson, Angela,23138 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Smith, Sarah, D,24099 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Gonzalez, Luke, P,16442 | 4923.29 | 0.00 | 0.00 | 2443.35 | 2479.94 |
| Roberts, Jeremy,24676 | 2461.55 | 0.00 | 0.00 | 0.00 | 2461.55 |
| Thomas, Noah, A,18352 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Kumar, Dawn, W,27794 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Oliver, Maria, C,25623 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Nath, Gregory,19634 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Mr., So, David,18145 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Green, Jordan, L,27915 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Davis, Brandon,24398 | 42.84 | 0.00 | 0.00 | 0.00 | 42.84 |
| Peterson, Nicole,21385 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Hall, Lucas,28760 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| He, Barbara, R,12470 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Cox, Steven, E,15964 | 3117.96 | 0.00 | 0.00 | 782.99 | 2334.97 |
| Wright, Jeremy, S,27223 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Morgan, Arianna,18155 | 86.46 | 0.00 | 0.00 | 0.00 | 86.46 |
| Luo, Clarence, M,28158 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Andersen, Kristin, K,11570 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Fernandez, Ebony,24663 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Lewis, Austin, C,13726 | 4500.82 | 0.00 | 0.00 | 2181.56 | 2319.26 |
| Nath, April, R,22824 | 2304.98 | 0.00 | 0.00 | 0.00 | 2304.98 |
| Foster, Jocelyn,20741 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Carter, Seth, A,20126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Thomas, Nathan, A,20330 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Powell, Stephanie, P,20210 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Scott, Charles, M,18863 | 2414.97 | 0.00 | 0.00 | 0.00 | 2414.97 |
| Walker, Joseph, E,18226 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Alvarez, Diane,26851 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Madan, Kristina, A,28698 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Foster, Kelly,21427 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| 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 |
| Butler, Jennifer, D,25478 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Gonzalez, Kevin,27668 | 6006.56 | 3578.27 | 0.00 | 0.00 | 2428.29 |
| Lee, Jennifer, R,14644 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Patel, Evelyn, W,18033 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Wilson, Anthony,21639 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Rodriguez, Ross, D,19045 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Lal, Eric,23578 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Hernandez, Elijah,13903 | 4511.54 | 0.00 | 0.00 | 2181.56 | 2329.98 |
| Hayes, Jacqueline, H,11409 | 4444.07 | 0.00 | 0.00 | 4444.07 | 0.00 |
| Jones, Jasmine, J,13320 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Robinson, Robert,12071 | 5973.24 | 0.00 | 3578.27 | 0.00 | 2394.97 |
| Mehta, Joe,17679 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Jackson,27220 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Bennett, Caroline,17508 | 2324.92 | 0.00 | 0.00 | 0.00 | 2324.92 |
| Bryant, Spencer, J,25025 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 |
| Smith, Samantha, J,14479 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| Rodriguez, Lauren,27037 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Butler, Emma, S,20394 | 1158.46 | 0.00 | 0.00 | 0.00 | 1158.46 |
| Cox, Jasmine,25086 | 1308.31 | 0.00 | 0.00 | 1308.31 | 0.00 |
| Cai, Brittney, L,25898 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Chande, Cristina,26233 | 48.97 | 0.00 | 0.00 | 48.97 | 0.00 |
| Shan, Katie,12534 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Thompson, Hunter,12976 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Long, Emma, F,24509 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| King, Jeremiah,17563 | 2397.91 | 0.00 | 0.00 | 0.00 | 2397.91 |
| Nicholls, Melody,27327 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Griffin, Samantha,25149 | 45.58 | 0.00 | 0.00 | 0.00 | 45.58 |
| Sun, Gilbert, L,12878 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Campbell, Rebecca,20687 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Alexander, Jessica, K,11780 | 5973.24 | 0.00 | 3578.27 | 0.00 | 2394.97 |
| Morris, Arianna, W,14999 | 57.51 | 0.00 | 0.00 | 0.00 | 57.51 |
| Watson, Evan, A,27452 | 4544.47 | 0.00 | 0.00 | 2071.42 | 2473.05 |
| Garcia, Cory, B,21546 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Smith, Brianna, D,15777 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, Grace, M,26237 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Alexander, Haley,11837 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Campbell, Katelyn, E,18071 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Robinson, Megan, G,16490 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Alvarez, Shannon,11551 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Murphy, Morgan, J,25391 | 1256.78 | 0.00 | 0.00 | 0.00 | 1256.78 |
| Campbell, Richard, A,19892 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Jones, Grace,11853 | 89.98 | 0.00 | 0.00 | 0.00 | 89.98 |
| Romero, Monique,22712 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Xie, Christy, C,25089 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Gonzalez, Regina, L,27116 | 4464.48 | 0.00 | 0.00 | 2071.42 | 2393.06 |
| Harris, Lucas, E,25901 | 5793.05 | 0.00 | 3399.99 | 0.00 | 2393.06 |
| Sanders, Alyssa, R,25007 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Ward, Cody,23166 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Hall, Jack, P,23050 | 69.97 | 0.00 | 0.00 | 69.97 | 0.00 |
| Chen, Jonathan, G,13096 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Stewart, Jesse,18913 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Murphy, Isaac, L,27225 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Hughes, Fernando,20120 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Ma, Sandra, N,17992 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Long, Ana,27035 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Torres, Billy, F,16286 | 6920.61 | 0.00 | 0.00 | 2181.56 | 4739.05 |
| Blue, Kaylee, M,28810 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Generated 2025-12-20 21:18:49.629 UTC