[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Malhotra, Cassandra, L,25756 | 2493.54 | 0.00 | 0.00 | 0.00 | 2493.54 |
| Suarez, Philip, M,26974 | 1292.81 | 0.00 | 0.00 | 0.00 | 1292.81 |
| Foster, Jason, A,12934 | 4551.53 | 0.00 | 2181.56 | 0.00 | 2369.97 |
| Williams, Robert, C,22873 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Morgan, Gabriella,20484 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Lee, Charles,23921 | 2465.28 | 0.00 | 0.00 | 0.00 | 2465.28 |
| Munoz, Erika,15114 | 6918.87 | 0.00 | 2181.56 | 2420.34 | 2316.97 |
| Martinez, James,26452 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Baker, Bailey,26271 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Scott, Robert, C,20438 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Ross, Ashley,21421 | 99.96 | 0.00 | 0.00 | 0.00 | 99.96 |
| Parker, Jonathan, D,15858 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Flores, Austin, J,16956 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Bryant, Cassidy,13208 | 4813.32 | 0.00 | 2443.35 | 0.00 | 2369.97 |
| Simmons, Trevor,12441 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Moore, Emma,26351 | 2800.44 | 0.00 | 0.00 | 2049.10 | 751.34 |
| Alvarez, Clinton,15625 | 7169.39 | 0.00 | 2443.35 | 0.00 | 4726.04 |
| Foster, Jasmine,27914 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| James, Sean,22068 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Foster, David, A,21294 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Sanders, Carlos,20127 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Anand, Shawn, J,14696 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Thompson, Wyatt,17194 | 111.45 | 0.00 | 0.00 | 0.00 | 111.45 |
| Rogers, Alexandra, M,24693 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Xie, Gregory,13992 | 1802.21 | 0.00 | 1000.44 | 0.00 | 801.77 |
| Carlson, Danny,27859 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Barnes, Hannah, W,14421 | 3369.41 | 0.00 | 0.00 | 1000.44 | 2368.97 |
| Romero, Derrick,29168 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Young, Andrea,22092 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Hall, Mason,22864 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Patel, Cindy, A,11249 | 9890.27 | 0.00 | 3399.99 | 2309.97 | 4180.31 |
| Rodriguez, Ivan, H,25305 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Baker, Savannah, C,11081 | 104.26 | 0.00 | 0.00 | 37.29 | 66.97 |
| Bryant, Ethan, L,13405 | 10778.61 | 0.00 | 3578.27 | 0.00 | 7200.34 |
| Morris, Morgan, P,11720 | 117.95 | 0.00 | 0.00 | 0.00 | 117.95 |
| Henderson, Ryan, M,25931 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Young, Stephanie, N,27430 | 33.43 | 0.00 | 0.00 | 0.00 | 33.43 |
| Parker, Carlos, C,20676 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Stone, Carmen, F,28722 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Evans, Richard,19641 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Mitchell, Robert,11658 | 111.96 | 0.00 | 0.00 | 0.00 | 111.96 |
| Suarez, Eddie, A,24109 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Baker, Lucas,11807 | 153.46 | 0.00 | 0.00 | 0.00 | 153.46 |
| Nath, Sharon, E,20061 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Ross, Aidan, D,11541 | 5973.24 | 0.00 | 3578.27 | 0.00 | 2394.97 |
| She, Terrence, S,17928 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Bryant, Ana,14141 | 3282.81 | 0.00 | 2443.35 | 0.00 | 839.46 |
| Andersen, Barbara, G,17984 | 6083.17 | 0.00 | 0.00 | 2443.35 | 3639.82 |
| Robinson, Nicholas,11174 | 48.56 | 0.00 | 0.00 | 0.00 | 48.56 |
| Russell, Robert, L,22875 | 556.26 | 0.00 | 0.00 | 0.00 | 556.26 |
| Lewis, Lauren,26800 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Dominguez, Dana, B,15117 | 6974.56 | 0.00 | 2181.56 | 0.00 | 4793.00 |
| Chander, Leonard,16586 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Luo, Tasha, R,15045 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Sanz, Diana,15098 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Romero, Gloria, R,13189 | 4765.63 | 0.00 | 2443.35 | 0.00 | 2322.28 |
| Henderson, Kaitlyn, J,12132 | 9716.00 | 0.00 | 0.00 | 5022.96 | 4693.04 |
| Howard, Jared, C,28053 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Evans, Marcus,27290 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Taylor, Miguel, C,23491 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Suarez, Roberto, D,18128 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Young, Alexandra, I,28452 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Mr., Sanchez, Thomas, T.,13228 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Morgan, Jennifer, L,19891 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| White, Thomas, S,14457 | 3359.90 | 0.00 | 0.00 | 1000.44 | 2359.46 |
| Kumar, Ryan,23793 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Foster, Melissa,20352 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Huang, Rafael, D,18520 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Scott, Sara, C,19317 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Allen, Jose, C,24053 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Lewis, Joshua, C,11848 | 92.27 | 0.00 | 0.00 | 0.00 | 92.27 |
| Patel, Darren, C,26990 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Washington, Melissa,12191 | 245.47 | 0.00 | 0.00 | 0.00 | 245.47 |
| Chande, Damien, A,12659 | 73.97 | 0.00 | 0.00 | 0.00 | 73.97 |
| Jenkins, Dylan, L,15773 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Sharma, Terry,14000 | 84.92 | 0.00 | 0.00 | 0.00 | 84.92 |
| Hughes, Hunter,14035 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Sanchez, Dominique, A,12208 | 5954.22 | 0.00 | 3578.27 | 0.00 | 2375.95 |
| Patterson, Fernando, E,26484 | 2813.77 | 0.00 | 0.00 | 2071.42 | 742.35 |
| Bryant, Jason,26485 | 2813.77 | 0.00 | 0.00 | 2071.42 | 742.35 |
| Zhang, Krystal, S,20163 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Ramos, Casey, C,14528 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Stewart, Adrian, C,11229 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Patterson, Elijah, A,26070 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 |
| Mitchell, Katherine, C,23204 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Sanchez, Alexa, J,19127 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 |
| Gray, Kaitlyn, L,14089 | 1893.91 | 0.00 | 1000.44 | 0.00 | 893.47 |
| Griffin, Ana,11960 | 74.98 | 0.00 | 0.00 | 39.99 | 34.99 |
| She, Suzanne,28902 | 2529.93 | 0.00 | 0.00 | 0.00 | 2529.93 |
| Miller, Jonathan, A,25356 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Evans, Noah, E,22724 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Powell, Eduardo,22108 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| White, Dalton, R,16765 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ma, Jon,17605 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ms., King, Amber, S,15935 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Long, James, Y,21844 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Morris, Adrian, F,15092 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Williams, Jessica, A,13594 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Cook, Alexa,12046 | 43.99 | 0.00 | 0.00 | 8.99 | 35.00 |
| Hall, Kevin, C,23216 | 613.45 | 0.00 | 0.00 | 0.00 | 613.45 |
| Campbell, Jenna, A,22876 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Luo, Tonya, A,29107 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Deng, Calvin,12254 | 2389.96 | 0.00 | 0.00 | 0.00 | 2389.96 |
| Jackson, Chloe, J,23864 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Russell, Vanessa, M,12917 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Zhang, Aaron, A,22768 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Coleman, Alexandra, A,19820 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Adams, Luis, R,22517 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Zhou, Christy,12435 | 5920.24 | 0.00 | 3578.27 | 0.00 | 2341.97 |
| Jackson, Justin, T,14392 | 3295.43 | 0.00 | 0.00 | 1000.44 | 2294.99 |
| Gonzalez, Thomas, M,18964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Yanagishima, Daisuke,26011 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 |
| Alonso, Randall,27960 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Barnes, Maria, J,20459 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Cooper, Angel,14997 | 4143.25 | 0.00 | 3578.27 | 0.00 | 564.98 |
| Rana, Douglas,24401 | 45.58 | 0.00 | 0.00 | 0.00 | 45.58 |
| Torres, Faith, A,14376 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Nath, Alisha,13556 | 6497.21 | 0.00 | 3578.27 | 0.00 | 2918.94 |
| Rogers, Hailey, L,13861 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Martin, Rebekah, M,27962 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lal, Thomas, E,24422 | 152.60 | 0.00 | 0.00 | 0.00 | 152.60 |
| Miller, Seth,20543 | 2492.32 | 0.00 | 0.00 | 0.00 | 2492.32 |
| Alexander, Carson, G,18106 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ortega, Jacquelyn, D,15305 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Gao, Warren, A,14608 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-11-04 06:22:24.770 UTC