[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 2625 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Morris, Ian, A,28070 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Gill, Carrie,28065 | 5997.33 | 3578.27 | 0.00 | 0.00 | 2419.06 |
| Harris, Charles, E,14591 | 1500.87 | 0.00 | 699.10 | 0.00 | 801.77 |
| Foster, Rachel,28018 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Cox, Alexa,20505 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Hernandez, Natalie, L,14565 | 1503.58 | 699.10 | 0.00 | 0.00 | 804.48 |
| Ward, Sara,14603 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Lee, Xavier, E,28039 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Coleman, Tristan,15883 | 89.95 | 0.00 | 0.00 | 0.00 | 89.95 |
| Hall, Sophia,27726 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| King, Savannah, H,28285 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Jackson, Olivia,27681 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Ray, Regina, B,25142 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Robinson, Rachel, J,28014 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Edwards, Maria, G,28298 | 4828.11 | 0.00 | 3578.27 | 1249.84 | 0.00 |
| Kelly, Megan,24784 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Rai, Misty, H,12457 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Wood, Amanda, S,28068 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Harris, Lucas, E,25901 | 5793.05 | 0.00 | 3399.99 | 0.00 | 2393.06 |
| Mehta, Francisco, K,17982 | 839.46 | 0.00 | 0.00 | 0.00 | 839.46 |
| Harris, Alexandra,12764 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Williams, Logan, M,28076 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Rodriguez, Isabella,28221 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Smith, Christopher, E,21233 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Murphy, Sara, M,12926 | 4795.31 | 0.00 | 2443.35 | 0.00 | 2351.96 |
| Mitchell, Jack, L,28040 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Davis, Jessica,28223 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Alan, Xavier,15384 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Kayla, E,24988 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Brown, Joseph, M,28042 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Sanchez, Kaylee,28362 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Jones, William,17342 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Russell, Kelly, E,19981 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Patterson, Jill,24349 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Diaz, Nicole,28264 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Rai, Keith, W,16396 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Sharma, Katrina, M,11614 | 4438.06 | 0.00 | 0.00 | 2049.10 | 2388.96 |
| Harris, Kaitlyn,24927 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Jenkins, Alexis,28294 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Rubio, Danny,11490 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Dominguez, Gary,17633 | 2732.70 | 0.00 | 0.00 | 1000.44 | 1732.26 |
| Lewis, Jacob, K,18799 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Collins, Wyatt, J,28295 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Moyer, Max, C,12980 | 4552.52 | 0.00 | 2181.56 | 0.00 | 2370.96 |
| Wood, Xavier,23732 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Torres, Kathleen,15260 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Adams, Jonathan,28247 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Butler, Hailey, D,19865 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| King, Noah,25876 | 4629.07 | 0.00 | 3374.99 | 0.00 | 1254.08 |
| Moreno, Nelson, R,17704 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Sharma, Ashlee, P,28664 | 4793.12 | 0.00 | 3578.27 | 0.00 | 1214.85 |
| Zhu, Alvin,28344 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Nath, Tamara,28064 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Ye, Karen, L,25476 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Miller, Richard, J,16884 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cooper, Isaac, I,28809 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Wright, Rebecca, J,28041 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Zhang, Jason, L,12796 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Martin, Brandi, A,15368 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Simmons, Kelly, S,29049 | 113.46 | 0.00 | 0.00 | 0.00 | 113.46 |
| Roberts, Xavier, C,28062 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Foster, Vanessa,16372 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 |
Generated 2025-12-23 11:55:08.461 UTC