[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 62 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Turner, Amber,11230 | 54.22 | 0.00 | 0.00 | 0.00 | 54.22 |
| Wu, Jessie, L,23792 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Hayes, Brandon,23199 | 45.22 | 0.00 | 0.00 | 0.00 | 45.22 |
| Zhu, Alvin,28344 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Cooper, Isaac, I,28809 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Rivera, Jennifer, S,15545 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Torres, Kimberly,14585 | 3016.07 | 699.10 | 0.00 | 0.00 | 2316.97 |
| Henderson, Aidan,28171 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Hayes, Nathan, K,25905 | 4598.83 | 0.00 | 3374.99 | 0.00 | 1223.84 |
| Ward, Sara,14603 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| King, Savannah, H,28285 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Dominguez, Tyrone, L,28250 | 6016.33 | 0.00 | 3578.27 | 0.00 | 2438.06 |
| Nelson, Jack, I,28234 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Harris, Lucas, E,25901 | 5793.05 | 0.00 | 3399.99 | 0.00 | 2393.06 |
| Rodriguez, Isabella,28221 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Davis, Jessica,28223 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Diaz, Gabriel,28586 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Sanchez, Kaylee,28362 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Long, Samuel, A,28270 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Cox, Shelby, V,28293 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Cox, Timothy,28196 | 5985.31 | 0.00 | 3578.27 | 0.00 | 2407.04 |
| Srini, Marco, A,28288 | 6039.30 | 0.00 | 3578.27 | 0.00 | 2461.03 |
| Clark, Robert, B,28255 | 6051.31 | 0.00 | 3578.27 | 0.00 | 2473.04 |
| Cooper, Juan, D,28794 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Collins, Edward, M,28627 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Campbell, Robert,28761 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Rowe, Latasha, L,28774 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Smith, Devin, T,28655 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Brown, Lauren,28651 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Flores, Aaron,14617 | 1538.56 | 0.00 | 699.10 | 0.00 | 839.46 |
| Serrano, Naomi,25916 | 4649.83 | 0.00 | 3399.99 | 0.00 | 1249.84 |
| Bailey, Brianna,28619 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Pal, Mohamed, C,28763 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Allen, Jesse,28795 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Powell, Kelly, L,14636 | 1538.58 | 0.00 | 699.10 | 0.00 | 839.48 |
| Mr., Adams, Ben,28678 | 4337.56 | 0.00 | 3578.27 | 759.29 | 0.00 |
| Yang, Nathan, D,28674 | 4430.09 | 0.00 | 3578.27 | 851.82 | 0.00 |
| Hayes, Ryan,28657 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Miller, Natalie, R,25910 | 4623.83 | 0.00 | 3399.99 | 0.00 | 1223.84 |
| Cox, Chloe,29126 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Perez, Harold, C,28988 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Davis, Miguel, J,28853 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Young, Lucas, M,22655 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Richardson, Gabriella,29046 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Richardson, Mariah,12410 | 159.99 | 0.00 | 0.00 | 0.00 | 159.99 |
| Baker, Kevin,13032 | 4740.63 | 0.00 | 2443.35 | 0.00 | 2297.28 |
| Cai, Alisha,19775 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Rubio, Marvin, R,22077 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Henderson, Jocelyn,25972 | 5780.99 | 0.00 | 3374.99 | 0.00 | 2406.00 |
| Alonso, Jon,25952 | 4598.83 | 0.00 | 3374.99 | 0.00 | 1223.84 |
| Hernandez, Caleb, A,28825 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Simmons, Kaitlyn,28845 | 4320.62 | 0.00 | 3578.27 | 0.00 | 742.35 |
| Reed, Alyssa,29128 | 4349.61 | 0.00 | 3578.27 | 0.00 | 771.34 |
| Watson, Mariah, R,28852 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Murphy, Andrea, R,28828 | 4329.61 | 0.00 | 3578.27 | 751.34 | 0.00 |
| Jackson, Blake,28821 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Xu, Carly, G,28847 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 |
| McDonald, Brianna,25943 | 5808.03 | 0.00 | 3374.99 | 0.00 | 2433.04 |
| Anderson, Anthony, A,25951 | 4703.31 | 0.00 | 3374.99 | 0.00 | 1328.32 |
| Winston, Christopher,25964 | 4649.83 | 0.00 | 3399.99 | 0.00 | 1249.84 |
| Li, Martha, M,28966 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Long, Gabriel,29017 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
Generated 2025-11-04 04:40:39.766 UTC