[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Raje, Leonard, D,13723 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Chande, Devon, L,12924 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Sanchez, Chloe,16151 | 639.45 | 0.00 | 0.00 | 0.00 | 639.45 |
| Zheng, Lacey, C,11417 | 11248.46 | 0.00 | 0.00 | 4511.07 | 6737.39 |
| Kapoor, Harold, S,25772 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Cai, Crystal, L,24062 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Anderson, Joseph, A,12777 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Butler, Antonio,12756 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Anderson, Edward, L,26328 | 4518.15 | 0.00 | 0.00 | 2049.10 | 2469.05 |
| Powell, Victoria,23016 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| James, Jacqueline, L,17209 | 7182.40 | 0.00 | 0.00 | 2443.35 | 4739.05 |
| Coleman, Aidan, L,20077 | 633.45 | 0.00 | 0.00 | 0.00 | 633.45 |
| Anand, Casey, F,25522 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Russell, Luis, A,12045 | 65.97 | 0.00 | 0.00 | 0.00 | 65.97 |
| Ye, Jorge, R,16426 | 5768.36 | 0.00 | 0.00 | 2181.56 | 3586.80 |
| Jiménez, Danny,16252 | 2781.54 | 0.00 | 0.00 | 2181.56 | 599.98 |
| Goldstein, Wyatt,22786 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| James, Natalie, M,21902 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Bryant, Aidan, R,15364 | 3183.94 | 0.00 | 0.00 | 782.99 | 2400.95 |
| White, Alyssa, L,15367 | 3177.96 | 0.00 | 0.00 | 782.99 | 2394.97 |
| Moreno, Philip, E,27004 | 1264.84 | 0.00 | 0.00 | 0.00 | 1264.84 |
| Long, Brittany, G,17615 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Diaz, Adam, H,23982 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Lewis, Cindy, C,16206 | 7203.35 | 0.00 | 0.00 | 2443.35 | 4760.00 |
| Suri, Nancy,19509 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Cai, Jaclyn,11386 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Arun, Ruben,20959 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ye, Lisa, L,27855 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Morgan, Brian, T,13181 | 185.96 | 0.00 | 0.00 | 128.99 | 56.97 |
| Bryant, Melissa,13218 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Jenkins, Miranda, L,13387 | 2337.27 | 0.00 | 0.00 | 0.00 | 2337.27 |
| Wang, Ernest,17038 | 2442.28 | 0.00 | 0.00 | 0.00 | 2442.28 |
| Wright, Angel,27845 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Butler, Sarah,26094 | 4648.31 | 0.00 | 3374.99 | 0.00 | 1273.32 |
| Rodriguez, Robert,14998 | 3058.31 | 0.00 | 0.00 | 2443.35 | 614.96 |
| Wagner, Ronnie,16513 | 4669.45 | 0.00 | 0.00 | 2181.56 | 2487.89 |
| Subram, Pamela, M,14167 | 4406.74 | 0.00 | 3578.27 | 0.00 | 828.47 |
| Davis, Destiny,11747 | 115.96 | 0.00 | 0.00 | 0.00 | 115.96 |
| Cook, Paige, L,24822 | 195.59 | 0.00 | 0.00 | 0.00 | 195.59 |
| Xie, Tamara,28384 | 67.59 | 0.00 | 0.00 | 0.00 | 67.59 |
| Stewart, Maria, D,20080 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Hill, Jose,18779 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kumar, Logan,14390 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ward, Grace, S,23356 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Rodriguez, Blake,28060 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carter, Luke, M,14635 | 37.21 | 0.00 | 0.00 | 0.00 | 37.21 |
| Wright, Natalie, J,13383 | 4511.54 | 0.00 | 2181.56 | 0.00 | 2329.98 |
| Clark, Katherine,17171 | 2439.99 | 0.00 | 0.00 | 0.00 | 2439.99 |
| Anand, Terrence, J,16204 | 7162.39 | 0.00 | 0.00 | 2443.35 | 4719.04 |
| Moore, Kaitlyn,23585 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Wright, David,18605 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Rivera, Stephanie, A,26828 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Hayes, Jonathan,26854 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Wang, Candice,19288 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Murphy, Kimberly,12961 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Diaz, Xavier, M,26813 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Kumar, Terry, E,20083 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ma, Glenn, M,16280 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Parker, Savannah, H,13204 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Raman, Toni,21530 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Nara, Peter, T,11770 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Simpson, Mindy, A,15200 | 3142.97 | 0.00 | 782.99 | 0.00 | 2359.98 |
Generated 2024-11-10 17:19:11.359 UTC