[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nelson, Jack, I,28234 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Carter, Sierra,20328 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Perry, Cassidy,28682 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Peterson, Taylor, P,26315 | 2825.43 | 0.00 | 0.00 | 2049.10 | 776.33 |
| Sanders, Jesse,20758 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Yang, David,14374 | 3362.71 | 0.00 | 0.00 | 1000.44 | 2362.27 |
| Yuan, Nicolas, J,19756 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gutierrez, Lee, A,14144 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Anderson, Hunter,15281 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Madan, Jermaine, C,15091 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alonso, Philip, L,22303 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Hall, Nicole,26203 | 188.98 | 0.00 | 0.00 | 0.00 | 188.98 |
| Mehta, Stanley, A,24143 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Harris, Dylan, L,28648 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Morgan, Gabrielle,15980 | 3077.98 | 0.00 | 0.00 | 782.99 | 2294.99 |
| Ma, Candice,27260 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Sharma, Deborah, R,13497 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Clark, Isabella,21330 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Sai, Chelsea,14845 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chander, Calvin,18124 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Scott, Elijah,29035 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Zhu, Franklin,15259 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Sato, Yiroyuki,21089 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Hill, Sara, K,17011 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Munoz, Jill, M,18174 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Kumar, Donna,15374 | 3177.96 | 0.00 | 0.00 | 782.99 | 2394.97 |
| Evans, Kaitlyn,13452 | 4800.30 | 0.00 | 0.00 | 2443.35 | 2356.95 |
| Howard, Katelyn, L,19174 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Yuan, Dawn, A,18801 | 1799.48 | 0.00 | 0.00 | 0.00 | 1799.48 |
| Gonzales, Sarah,13871 | 3060.52 | 0.00 | 0.00 | 2181.56 | 878.96 |
| Taylor, Elizabeth, P,21901 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Richardson, Dalton, W,11679 | 145.96 | 0.00 | 0.00 | 0.00 | 145.96 |
| Gill, Brandi, D,12124 | 9617.37 | 0.00 | 0.00 | 4879.35 | 4738.02 |
| Ma, Brent,20428 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Lopez, Allison, D,14098 | 1845.90 | 0.00 | 0.00 | 1000.44 | 845.46 |
| Anderson, Brandon, S,16222 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Watson, Angela, M,22391 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Lopez, Kyle,28061 | 6006.32 | 0.00 | 3578.27 | 0.00 | 2428.05 |
| Rubio, Diane,24818 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Nara, Jenny,11438 | 34.99 | 0.00 | 0.00 | 34.99 | 0.00 |
| Li, Logan,13800 | 3262.83 | 0.00 | 2443.35 | 0.00 | 819.48 |
| Alexander, Eric, S,28185 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Cook, Mason, M,17614 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Gonzales, Marcus, M,25334 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Perez, Carla,11567 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Bell, Savannah,25417 | 1308.31 | 0.00 | 0.00 | 0.00 | 1308.31 |
| Beck, Christy, A,19366 | 1617.46 | 0.00 | 0.00 | 782.99 | 834.47 |
| Flores, Benjamin,18025 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| White, Blake, P,12792 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Alonso, Jay, A,15675 | 7206.38 | 0.00 | 0.00 | 2443.35 | 4763.03 |
| Li, Jose, K,11725 | 123.91 | 0.00 | 0.00 | 0.00 | 123.91 |
| Jiménez, Dana,19257 | 2739.90 | 0.00 | 0.00 | 1000.44 | 1739.46 |
| Murphy, Cindy, M,19655 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Cook, Eduardo,21924 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Griffin, Ana,11960 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Alexander, Arianna,17423 | 2297.28 | 0.00 | 0.00 | 0.00 | 2297.28 |
| Yang, Brandon,24351 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Brooks, Juan,18516 | 2404.91 | 0.00 | 0.00 | 0.00 | 2404.91 |
| Jai, Peter,13686 | 2914.97 | 0.00 | 0.00 | 0.00 | 2914.97 |
| Xu, Warren,24762 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Gonzalez, Hunter, C,25201 | 96.07 | 0.00 | 0.00 | 0.00 | 96.07 |
| Patterson, Jason,20385 | 2528.33 | 0.00 | 0.00 | 0.00 | 2528.33 |
| Campbell, Isaiah,20405 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Tang, Corey,22649 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ferrier, Grant,20898 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Nara, Colleen, L,14798 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Thompson, Eduardo,19157 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Campbell, Aaron, C,21151 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gonzales, Connor, M,16923 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Kelly, Melissa,16037 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Watson, Natalie,25765 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Shan, Andres, T,13560 | 2874.96 | 0.00 | 0.00 | 0.00 | 2874.96 |
| Chandra, Francisco, A,12440 | 5913.25 | 0.00 | 3578.27 | 0.00 | 2334.98 |
| Blanco, Andy,14923 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Collins, Wyatt, J,28295 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Walker, Daniel, E,18661 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yang, Noah,26602 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Simmons, Antonio,26490 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Mitchell, Miguel,28851 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Johnson, Grace, M,18093 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Prasad, Adriana, W,20050 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Liang, Karen, M,21048 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Arthur, Tina, L,15706 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Sharma, Brandon,22220 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Xu, Todd,28456 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Flores, Oscar, L,29415 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Smith, Rachael, K,23461 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Rodriguez, William,28274 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Anderson, Liz,20701 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Nath, Peter, K,28441 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Patterson, Adam, M,19696 | 597.26 | 0.00 | 0.00 | 0.00 | 597.26 |
| Price, Katherine, R,19544 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Hall, Stephanie, E,22865 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Smith, Kristina, D,19490 | 62.97 | 0.00 | 0.00 | 0.00 | 62.97 |
| Peterson, Sara,13304 | 4612.51 | 0.00 | 0.00 | 2181.56 | 2430.95 |
| Deng, Alison, W,24567 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Diaz, Casey, S,29356 | 628.97 | 0.00 | 0.00 | 628.97 | 0.00 |
| Harris, Olivia, J,21638 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Hall, Chloe, L,22129 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Long, Jason,14391 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Bennett, Taylor, L,28972 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Cooper, Richard, L,16833 | 2343.96 | 0.00 | 0.00 | 0.00 | 2343.96 |
| Hernandez, Aaron,18770 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Shan, Kelli,17843 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Gonzales, Aaron,18804 | 1810.46 | 0.00 | 0.00 | 0.00 | 1810.46 |
| Raje, Colin,26378 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Rubio, Deanna, T,19573 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Butler, Dylan,20121 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hernandez, Jesse, D,27238 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Hughes, Oscar, B,22590 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Sanchez, Jennifer, J,27203 | 18.97 | 0.00 | 0.00 | 0.00 | 18.97 |
| Miller, Brianna,24931 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Patel, Francisco,15443 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Bryant, Cameron,15371 | 3178.95 | 0.00 | 0.00 | 782.99 | 2395.96 |
| Butler, Kaitlyn, O,19286 | 2755.42 | 0.00 | 0.00 | 1000.44 | 1754.98 |
| Prasad, Michele, C,21862 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Raje, Sharon, M,28707 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Ruiz, Gary,21097 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Adams, Jesse, M,17172 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Clark, Logan,18039 | 2450.08 | 0.00 | 699.10 | 0.00 | 1750.98 |
| Van, Candace, S,15160 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Bennett, Jennifer, G,13708 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Chandra, Raymond, F,22463 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Jai, Chad, C,11672 | 113.48 | 0.00 | 0.00 | 0.00 | 113.48 |
| Navarro, Desiree,15520 | 1611.96 | 0.00 | 0.00 | 782.99 | 828.97 |
Generated 2025-12-22 02:33:47.410 UTC