[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Bryant, Xavier, R,22130 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Bryant, Taylor, D,15901 | 1376.97 | 0.00 | 0.00 | 782.99 | 593.98 |
| Zeng, Gilbert, C,20914 | 1926.45 | 0.00 | 0.00 | 782.99 | 1143.46 |
| Howard, Jacqueline, H,19285 | 2751.42 | 0.00 | 0.00 | 1000.44 | 1750.98 |
| Richardson, Isaiah,20970 | 1962.46 | 0.00 | 0.00 | 782.99 | 1179.47 |
| Cooper, Haley,15897 | 3114.94 | 0.00 | 0.00 | 782.99 | 2331.95 |
| Chander, Mindy,27421 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Lu, Damien, M,15944 | 3234.94 | 0.00 | 0.00 | 782.99 | 2451.95 |
| Cai, Kelli, R,11402 | 5059.33 | 0.00 | 0.00 | 5059.33 | 0.00 |
| Garcia, Stanley, R,19294 | 2820.39 | 0.00 | 0.00 | 1000.44 | 1819.95 |
| Garcia, John, M,16432 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Gonzalez, Alex, A,14452 | 3377.40 | 0.00 | 0.00 | 1000.44 | 2376.96 |
| Goel, Maurice,11410 | 4464.07 | 0.00 | 0.00 | 4464.07 | 0.00 |
| Bennett, Janice,15904 | 1394.95 | 0.00 | 0.00 | 782.99 | 611.96 |
| Butler, Dakota,27423 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Gill, Nelson, G,17934 | 3907.04 | 0.00 | 0.00 | 2181.56 | 1725.48 |
| Clark, Jacob,27264 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Brooks, Katelyn,27279 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Bryant, Logan, A,15914 | 3080.27 | 0.00 | 0.00 | 782.99 | 2297.28 |
| Martin, Samantha,27541 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Liang, Jon, R,21042 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Garcia, Summer, D,28700 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Zhao, Todd,23991 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Jenkins, Gavin,28033 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Cook, Jennifer, J,23550 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Lee, Seth, C,23006 | 39.47 | 0.00 | 0.00 | 0.00 | 39.47 |
| Gonzalez, Caleb,12826 | 4428.37 | 0.00 | 0.00 | 2071.42 | 2356.95 |
| Zeng, Ronnie, L,12806 | 4956.05 | 0.00 | 0.00 | 4416.06 | 539.99 |
| Young, Sydney, K,21006 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Gonzales, Gabriel, M,13927 | 3021.04 | 0.00 | 0.00 | 3021.04 | 0.00 |
| Rubio, Julio,17945 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Pal, Shawn,27286 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Hill, Courtney,27262 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Blanco, Tyrone, F,19458 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Brooks, Bailey, M,15941 | 3105.27 | 0.00 | 0.00 | 782.99 | 2322.28 |
| Lopez, Ruth, D,17902 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Ye, Jorge, R,16426 | 5768.36 | 0.00 | 0.00 | 2181.56 | 3586.80 |
| Patel, Johnathan,19289 | 2765.40 | 0.00 | 0.00 | 1000.44 | 1764.96 |
| Wilson, David, M,15908 | 1413.93 | 0.00 | 0.00 | 782.99 | 630.94 |
| Wang, Candice,19288 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Tang, Roger, M,20945 | 1953.47 | 0.00 | 0.00 | 782.99 | 1170.48 |
| Allen, Samuel, W,13917 | 3282.81 | 0.00 | 0.00 | 3282.81 | 0.00 |
| Price, Faith, L,21624 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Martinez, Kristopher,13467 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Reed, Dalton,24432 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Martinez, Noah, R,25060 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Srini, Brandy, W,26988 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Green, Jack,12137 | 92.27 | 0.00 | 0.00 | 42.28 | 49.99 |
| Powell, Edward, S,29112 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Thompson, Jasmine, A,18659 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| She, Suzanne,28902 | 2529.93 | 0.00 | 0.00 | 0.00 | 2529.93 |
| Evans, Noah, E,22724 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Serrano, Billy, P,24080 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Edwards, Mary, B,14481 | 3360.42 | 0.00 | 0.00 | 1000.44 | 2359.98 |
| Brown, Alexandra, R,13977 | 4788.57 | 0.00 | 0.00 | 2443.35 | 2345.22 |
| Coleman, Jonathan, R,14486 | 3310.41 | 0.00 | 0.00 | 1000.44 | 2309.97 |
| Mehta, Candace,11588 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Murphy, Sean,15969 | 3109.95 | 0.00 | 0.00 | 782.99 | 2326.96 |
| Ms., Snowden, Victoria, L.,17900 | 2751.42 | 0.00 | 0.00 | 1000.44 | 1750.98 |
| Campbell, Savannah,15989 | 3140.92 | 0.00 | 0.00 | 782.99 | 2357.93 |
| Gonzalez, Gabriel, R,14471 | 3355.43 | 0.00 | 0.00 | 1000.44 | 2354.99 |
| Carlson, Teresa, L,12852 | 4411.37 | 0.00 | 0.00 | 2049.10 | 2362.27 |
Generated 2024-09-20 19:36:43.980 UTC