[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nath, Kathryn,28632 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Moreno, Jill, E,13537 | 5910.22 | 0.00 | 3578.27 | 0.00 | 2331.95 |
| Romero, Jonathon,26268 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Ramos, Nelson, J,14990 | 4173.19 | 0.00 | 3578.27 | 0.00 | 594.92 |
| Garcia, Andrew, J,23242 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Sanders, Katelyn, A,12181 | 5958.74 | 0.00 | 3578.27 | 0.00 | 2380.47 |
| Evans, Evan,23181 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Williams, Megan, A,12884 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Rivera, Sydney, M,23736 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Perez, Deanna,11428 | 9954.26 | 0.00 | 3399.99 | 0.00 | 6554.27 |
| Blanco, Sabrina,13564 | 5932.22 | 0.00 | 3578.27 | 0.00 | 2353.95 |
| Clark, Daniel, L,15016 | 1498.58 | 0.00 | 699.10 | 0.00 | 799.48 |
| Clark, Abigail,12772 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Campbell, Madeline,12898 | 5958.74 | 0.00 | 3578.27 | 0.00 | 2380.47 |
| Martinez, Rebekah, A,12721 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Alexander, Kaitlyn, T,12915 | 5896.19 | 0.00 | 3578.27 | 0.00 | 2317.92 |
| Howard, Katherine,14915 | 1538.58 | 0.00 | 699.10 | 0.00 | 839.48 |
| Alvarez, Ruben,12543 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Zhu, Cedric, T,20723 | 143.96 | 0.00 | 0.00 | 0.00 | 143.96 |
| Jenkins, Ashley,21091 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Sai, Nancy, B,23440 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Jones, Alexis, M,12179 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Long, Jocelyn,12886 | 5965.22 | 0.00 | 3578.27 | 0.00 | 2386.95 |
| Russell, Isabelle, S,13327 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Evans, Jan, M,20029 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Butler, Antonio,12756 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Andersen, Lindsey, S,13261 | 3622.31 | 0.00 | 0.00 | 0.00 | 3622.31 |
| Malhotra, Kari, J,15063 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Zheng, Autumn, A,19041 | 3089.08 | 0.00 | 699.10 | 0.00 | 2389.98 |
| Carlson, Randall, T,13829 | 801.77 | 0.00 | 0.00 | 0.00 | 801.77 |
| Dominguez, Desiree, S,11427 | 9917.99 | 0.00 | 3399.99 | 0.00 | 6518.00 |
| Garcia, Bryant,11431 | 9912.98 | 0.00 | 3399.99 | 0.00 | 6512.99 |
| Campbell, Sierra, M,23822 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Patel, Allen, J,22049 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Flores, Robert,26097 | 5773.04 | 0.00 | 3374.99 | 0.00 | 2398.05 |
| Gray, Arianna,14914 | 1592.57 | 0.00 | 699.10 | 0.00 | 893.47 |
| Jai, Thomas,12904 | 5915.53 | 0.00 | 3578.27 | 0.00 | 2337.26 |
| Wright, Kevin, A,26096 | 5843.54 | 0.00 | 3399.99 | 0.00 | 2443.55 |
| Henderson, Hannah,14570 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Luo, Jaclyn,16429 | 4958.28 | 0.00 | 0.00 | 2443.35 | 2514.93 |
| McDonald, Seth,24265 | 96.07 | 0.00 | 0.00 | 0.00 | 96.07 |
| Shen, Drew, L,13674 | 148.47 | 0.00 | 0.00 | 0.00 | 148.47 |
| Madan, Mayra, M,19027 | 3029.08 | 0.00 | 699.10 | 0.00 | 2329.98 |
| Alvarez, Latasha,18047 | 2736.42 | 0.00 | 1000.44 | 0.00 | 1735.98 |
| Martinez, Adriana, S,15457 | 2781.54 | 0.00 | 2181.56 | 0.00 | 599.98 |
| Powell, Samantha,25390 | 1274.33 | 0.00 | 0.00 | 0.00 | 1274.33 |
| Hernandez, Isabella,13220 | 4682.53 | 0.00 | 2181.56 | 0.00 | 2500.97 |
| Bennett, Kaitlyn, L,16942 | 2751.42 | 0.00 | 1000.44 | 0.00 | 1750.98 |
| Munoz, Erika,15114 | 6918.87 | 0.00 | 2181.56 | 0.00 | 4737.31 |
| Shan, Zachary,24359 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Ramirez, Mackenzie, M,15116 | 7212.86 | 0.00 | 2443.35 | 0.00 | 4769.51 |
| Williams, Robert, C,22873 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Deng, Andres,13667 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Garcia, Logan, D,17095 | 2760.41 | 0.00 | 1000.44 | 0.00 | 1759.97 |
| Garcia, Morgan, R,26252 | 3300.22 | 0.00 | 2049.10 | 0.00 | 1251.12 |
| Adams, Isaac,26174 | 2071.42 | 0.00 | 2071.42 | 0.00 | 0.00 |
| Alexander, Alexandria,26333 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Perez, Douglas,19924 | 3171.95 | 0.00 | 782.99 | 0.00 | 2388.96 |
| Jai, Jonathan,24962 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Ross, Samuel, T,15957 | 163.99 | 0.00 | 0.00 | 0.00 | 163.99 |
| Schmidt, Ruth, L,28506 | 3213.57 | 0.00 | 2049.10 | 0.00 | 1164.47 |
| Parker, Jonathan, D,15858 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Generated 2025-12-21 22:35:13.385 UTC