[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lal, Austin, M,23066 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Foster, Eduardo,11926 | 47.94 | 0.00 | 0.00 | 0.00 | 47.94 |
| Nath, Kathryn,28632 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Martinez, Rebekah, A,12721 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Mitchell, Kevin,23352 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Coleman, Victoria, O,23708 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Lewis, Richard, I,21637 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Chen, Kelli,19325 | 3546.12 | 0.00 | 0.00 | 0.00 | 3546.12 |
| Gray, Ian, A,11193 | 41.28 | 0.00 | 0.00 | 35.00 | 6.28 |
| Mitchell, Sydney,29026 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sanders, Victoria,29078 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Wilson, Sarah, C,27098 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Ramos, Hector,15667 | 3125.32 | 0.00 | 2443.35 | 0.00 | 681.97 |
| Anderson, Hannah, C,11883 | 77.27 | 0.00 | 0.00 | 42.28 | 34.99 |
| Turner, Devin, J,23464 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Smith, Wyatt, P,23147 | 157.27 | 0.00 | 0.00 | 0.00 | 157.27 |
| James, Gabrielle,12725 | 127.28 | 0.00 | 0.00 | 0.00 | 127.28 |
| Simmons, Nathan, M,11043 | 47.98 | 0.00 | 0.00 | 0.00 | 47.98 |
| Wilson, Cameron,21498 | 134.98 | 0.00 | 0.00 | 0.00 | 134.98 |
| Nara, Deborah, E,13502 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Coleman, Lauren,13419 | 4476.55 | 0.00 | 2181.56 | 0.00 | 2294.99 |
| Turner, Jordan, B,13420 | 4798.33 | 0.00 | 2443.35 | 0.00 | 2354.98 |
| Gonzalez, Allison,11745 | 5948.23 | 0.00 | 3578.27 | 0.00 | 2369.96 |
| Thomas, Lucas, E,13315 | 4541.53 | 0.00 | 2181.56 | 0.00 | 2359.97 |
| Nara, Warren, M,25105 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Gutierrez, Tanya,17714 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Carlson, Randall, T,13829 | 801.77 | 0.00 | 0.00 | 0.00 | 801.77 |
| Young, Bailey, R,24725 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Young, Jesse, E,18676 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Collins, Stephanie,11261 | 6650.60 | 0.00 | 3578.27 | 2329.98 | 742.35 |
| Cox, Jasmine,25086 | 1308.31 | 0.00 | 0.00 | 1308.31 | 0.00 |
| Zhou, Suzanne,12130 | 7987.91 | 0.00 | 0.00 | 5589.86 | 2398.05 |
| Romero, Kendra,26826 | 1237.82 | 0.00 | 0.00 | 1237.82 | 0.00 |
| Phillips, Seth,11292 | 5910.22 | 0.00 | 3578.27 | 2331.95 | 0.00 |
| Rogers, Morgan, B,11674 | 96.27 | 0.00 | 0.00 | 0.00 | 96.27 |
| Suarez, Erik, W,15194 | 3173.94 | 0.00 | 782.99 | 0.00 | 2390.95 |
| Gutierrez, Ruben, A,20835 | 2002.44 | 0.00 | 0.00 | 782.99 | 1219.45 |
| Zhao, Ronnie,17955 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Lal, Dale,12324 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Edwards, Jennifer,12962 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Rai, Bridget, L,17542 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Raje, Clayton, P,20888 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Zheng, Margaret, D,13823 | 5393.31 | 0.00 | 2443.35 | 0.00 | 2949.96 |
| Alonso, Paula, L,22692 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Zhang, Eugene, C,27887 | 39.47 | 0.00 | 0.00 | 0.00 | 39.47 |
| Subram, Joel, L,20873 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Simmons, Isabelle,25730 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 |
| Becker, Jaime, J,28278 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhang, Todd,20590 | 3127.25 | 0.00 | 0.00 | 782.99 | 2344.26 |
| Howard, Chase, K,18892 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Washington, Jordan,27779 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carlson, Jaime, J,17470 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Powell, Jacqueline,11257 | 6677.38 | 0.00 | 3578.27 | 2297.28 | 801.83 |
| Fernandez, Virginia,29355 | 567.76 | 0.00 | 0.00 | 567.76 | 0.00 |
| Morgan, Caitlin, C,19167 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Raji, Alejandro, E,16944 | 4253.81 | 0.00 | 0.00 | 4253.81 | 0.00 |
| Cai, Marshall, K,25779 | 2479.94 | 0.00 | 0.00 | 2479.94 | 0.00 |
| Taylor, William, A,15839 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Wilson, Miguel,13414 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Watson, Brian,28870 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 |
| Andersen, Alisha,25460 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Deng, Darrell, A,25450 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Sanchez, Joe, S,16552 | 4986.79 | 0.00 | 0.00 | 2443.35 | 2543.44 |
| Phillips, Robert,27374 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ruiz, Dwayne, A,26323 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Thompson, Anna,27200 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Peterson, Abigail, L,23448 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Hu, Arturo, R,14663 | 104.95 | 0.00 | 0.00 | 0.00 | 104.95 |
| Baker, Kaylee,11703 | 100.27 | 0.00 | 0.00 | 62.98 | 37.29 |
| Arun, Kristina, V,20716 | 3911.29 | 0.00 | 0.00 | 1560.33 | 2350.96 |
| Lin, Stacey, B,24883 | 2487.33 | 0.00 | 0.00 | 2487.33 | 0.00 |
| Sanchez, Natalie,18958 | 565.21 | 0.00 | 0.00 | 565.21 | 0.00 |
| Ramos, Deanna, D,11332 | 5754.97 | 0.00 | 3399.99 | 2354.98 | 0.00 |
| Gonzales, Dalton,21456 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Simmons, Aaron,13891 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Adams, Richard, R,22104 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Bryant, Elizabeth,17407 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Lewis, Blake,17390 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wood, Elizabeth, D,26312 | 2881.74 | 0.00 | 2071.42 | 810.32 | 0.00 |
| Shan, Julie, M,13789 | 819.48 | 0.00 | 0.00 | 819.48 | 0.00 |
| Diaz, David,11267 | 5943.23 | 0.00 | 3578.27 | 2364.96 | 0.00 |
| Jackson, Emily,25092 | 1257.82 | 0.00 | 0.00 | 1257.82 | 0.00 |
| Allen, Courtney, M,22260 | 563.77 | 0.00 | 0.00 | 563.77 | 0.00 |
| Phillips, Natalie,22415 | 615.47 | 0.00 | 0.00 | 615.47 | 0.00 |
| Collins, Aaron, P,27663 | 6047.32 | 3578.27 | 0.00 | 0.00 | 2469.05 |
| Turner, Madeline,23845 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Bennett, Mya, M,18568 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Suarez, Jonathon, P,19944 | 3105.27 | 0.00 | 782.99 | 0.00 | 2322.28 |
| Torres, Angel,21290 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Gomez, Leslie,17684 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Li, Dennis,14837 | 116.95 | 0.00 | 0.00 | 0.00 | 116.95 |
| Mehta, Clifford,26902 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Ramirez, Arianna, C,22897 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Huang, Jaclyn,18148 | 1518.58 | 0.00 | 699.10 | 0.00 | 819.48 |
| Morgan, Julia, E,26809 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Morgan, Haley, A,13741 | 2951.05 | 0.00 | 0.00 | 2951.05 | 0.00 |
| Harris, Christopher, A,24417 | 2467.02 | 0.00 | 0.00 | 2467.02 | 0.00 |
| Mitchell, Noah,25722 | 777.34 | 0.00 | 0.00 | 777.34 | 0.00 |
| Walker, Megan, G,11154 | 2319.99 | 0.00 | 0.00 | 2319.99 | 0.00 |
| Johnson, Joshua,20939 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Shan, Karl, J,11389 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Liang, Willie, M,19484 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Green, Jose, C,27320 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Powell, Luke, A,12175 | 155.00 | 0.00 | 0.00 | 0.00 | 155.00 |
| Ramirez, Dalton, R,15256 | 1631.46 | 0.00 | 782.99 | 0.00 | 848.47 |
| Flores, Isabel,23715 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Hughes, Gabrielle,23724 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Wang, Adam, L,21340 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Patterson, Elizabeth, E,13322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Williams, Taylor,13426 | 4498.53 | 0.00 | 2181.56 | 0.00 | 2316.97 |
| Stiller, Florian, L,13324 | 4526.78 | 0.00 | 2181.56 | 0.00 | 2345.22 |
| Butler, James, C,23112 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Shan, Austin,21465 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Price, Edward,21438 | 561.48 | 0.00 | 0.00 | 561.48 | 0.00 |
| Martin, Dana, K,16231 | 2525.94 | 0.00 | 0.00 | 2525.94 | 0.00 |
| Torres, Melanie, L,19171 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Murphy, Angela,11063 | 2372.95 | 0.00 | 0.00 | 2372.95 | 0.00 |
| Miller, Alexander,26307 | 2848.76 | 0.00 | 2071.42 | 777.34 | 0.00 |
| Li, Jonathan, E,23837 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Wilson, Arthur,18762 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Cooper, Gabriella, L,18596 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Vance, Ronald,25459 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Jimenez, Larry, M,26363 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| James, Lauren, T,28815 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Powell, Benjamin, F,25968 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
Generated 2025-11-02 06:01:41.417 UTC