[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 15 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Alex, A,14452 | 3377.40 | 0.00 | 0.00 | 1000.44 | 2376.96 |
| Parker, Jack,17270 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Johnston, Richard,28791 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Moyer, Jay,13822 | 2944.94 | 0.00 | 0.00 | 0.00 | 2944.94 |
| Rivera, Sydney, M,23736 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Ross, Lauren,11794 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Li, Jose, K,11725 | 123.91 | 0.00 | 0.00 | 0.00 | 123.91 |
| Simmons, Luke, J,16330 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Simmons, Miranda, L,21906 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Chander, Tony,13653 | 4546.79 | 0.00 | 0.00 | 2181.56 | 2365.23 |
| Peterson, Faith,28593 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Edwards, Amanda,16127 | 618.47 | 0.00 | 0.00 | 0.00 | 618.47 |
| Morgan, Jada, A,11520 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Nath, Edwin,24181 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ortega, Melinda, L,12862 | 117.58 | 0.00 | 0.00 | 0.00 | 117.58 |
| Barnes, Antonio,18688 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Jackson, Cameron, H,24752 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Roberts, Kaylee, G,20490 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Gray, Xavier,28643 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Walker, Thomas,13071 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Edwards, Kevin, L,14734 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Cook, Cody, K,12450 | 5955.23 | 0.00 | 3578.27 | 0.00 | 2376.96 |
| Vance, Adriana,26983 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| She, Shawn, J,16902 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Suarez, Tanya, B,17745 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Washington, Katherine,26708 | 4504.46 | 0.00 | 0.00 | 2071.42 | 2433.04 |
| Zhou, Jorge, M,22319 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Rana, Abby, P,14534 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Bryant, Austin, L,11529 | 5944.21 | 0.00 | 3578.27 | 2365.94 | 0.00 |
| James, Garrett,12443 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Kumar, Christian, L,29006 | 151.27 | 0.00 | 0.00 | 0.00 | 151.27 |
| Nelson, Jenna, D,21448 | 564.48 | 0.00 | 0.00 | 564.48 | 0.00 |
| Nara, Jerry,22491 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Smith, Robert,15113 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Ye, Jorge, R,16426 | 5768.36 | 0.00 | 0.00 | 2181.56 | 3586.80 |
| Martinez, Marie,16273 | 2803.52 | 0.00 | 0.00 | 2181.56 | 621.96 |
| Wilson, Alyssa,12897 | 106.96 | 0.00 | 0.00 | 0.00 | 106.96 |
| Carter, Chloe,23836 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Subram, Brett, B,16917 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Patel, Andre, R,16415 | 4930.68 | 0.00 | 0.00 | 2443.35 | 2487.33 |
| Alonso, Paula, L,22692 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Parker, Sophia, E,15895 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Alonso, Neil, M,13332 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Smith, Cameron, M,13589 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Zheng, Steve, D,19877 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Suri, Bryant, E,18152 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Price, Mariah, C,20745 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Patel, Lydia, B,29414 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Martinez, Ross, G,28494 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Garcia, Kari,14805 | 101.46 | 0.00 | 0.00 | 0.00 | 101.46 |
| Sanders, Destiny,24308 | 612.95 | 0.00 | 0.00 | 0.00 | 612.95 |
| Bryant, Abigail, K,22042 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Powell, Brandon,23081 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Campbell, Jenna, A,22876 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Perez, Troy, D,16284 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Watson, Jesse,20100 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Liang, Edwin, W,12327 | 13.98 | 0.00 | 0.00 | 8.99 | 4.99 |
| Chande, Tasha, A,28528 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Chen, Micah,16087 | 2369.97 | 0.00 | 0.00 | 0.00 | 2369.97 |
| Subram, Molly, C,25586 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 |
Generated 2025-12-21 15:24:11.285 UTC