[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1122 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| James, Devin,20031 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Cook, Katelyn, E,12787 | 53.56 | 0.00 | 0.00 | 0.00 | 53.56 |
| Hu, Christy, G,20912 | 2373.79 | 0.00 | 0.00 | 782.99 | 1590.80 |
| Anand, Latoya, D,28347 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Lee, Lucas, J,26628 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Pal, Priscilla, J,15928 | 6960.08 | 0.00 | 0.00 | 2181.56 | 4778.52 |
| Zhang, Justin,26322 | 2912.26 | 0.00 | 0.00 | 2071.42 | 840.84 |
| Sara, Lydia,14037 | 1898.90 | 0.00 | 0.00 | 1000.44 | 898.46 |
| Cox, Brianna,15329 | 3134.95 | 0.00 | 0.00 | 782.99 | 2351.96 |
| Phillips, Blake,15321 | 3112.98 | 0.00 | 0.00 | 782.99 | 2329.99 |
| Ms., Wright, Amanda,26317 | 2862.74 | 0.00 | 0.00 | 2071.42 | 791.32 |
| Jones, Anthony, L,13461 | 4476.55 | 0.00 | 0.00 | 2181.56 | 2294.99 |
| Diaz, Marie,15333 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Sun, Darryl, L,28708 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Raje, Kelvin, V,20555 | 3153.95 | 0.00 | 0.00 | 782.99 | 2370.96 |
| Carter, Greg, G,15348 | 3198.45 | 0.00 | 0.00 | 782.99 | 2415.46 |
| Coleman, Anna,26338 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Hernandez, Sydney,13456 | 4582.51 | 0.00 | 0.00 | 2181.56 | 2400.95 |
| Fernandez, Henry, A,14779 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Turner, Angel, L,16278 | 2992.33 | 0.00 | 0.00 | 2443.35 | 548.98 |
| Griffin, Eduardo, M,26342 | 4489.47 | 0.00 | 0.00 | 2071.42 | 2418.05 |
| Ma, Vincent, W,26487 | 4456.14 | 0.00 | 0.00 | 2049.10 | 2407.04 |
| Deng, Lacey,15341 | 1622.47 | 0.00 | 0.00 | 782.99 | 839.48 |
| James, Cindy,26339 | 4455.49 | 0.00 | 0.00 | 2071.42 | 2384.07 |
| Hall, Isabella,18157 | 3399.41 | 0.00 | 0.00 | 1000.44 | 2398.97 |
| Hernandez, Jerome,16270 | 2771.52 | 0.00 | 0.00 | 2181.56 | 589.96 |
| Morris, Jennifer, D,20549 | 3105.27 | 0.00 | 0.00 | 782.99 | 2322.28 |
| Chandra, Cory, J,28690 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Deng, Ashlee,14791 | 7210.85 | 0.00 | 0.00 | 2443.35 | 4767.50 |
| Moreno, Audrey,14802 | 3287.32 | 0.00 | 0.00 | 2443.35 | 843.97 |
| Gutierrez, Michele, K,16271 | 3014.31 | 0.00 | 0.00 | 2443.35 | 570.96 |
| Munoz, Kristy, E,12128 | 8681.11 | 0.00 | 0.00 | 2049.10 | 6632.01 |
| Bennett, Miguel,26546 | 2847.75 | 0.00 | 0.00 | 2071.42 | 776.33 |
| Gonzalez, Andrea, M,22891 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Watson, Danielle,18572 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Anderson, Nathan,14876 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Wilson, Justin,11842 | 98.97 | 0.00 | 0.00 | 0.00 | 98.97 |
| Cooper, Carol, D,12605 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Murphy, Patrick, M,14334 | 1848.91 | 0.00 | 0.00 | 1000.44 | 848.47 |
| Kumar, Colleen, R,21912 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Pal, Andres, S,14931 | 6980.85 | 0.00 | 0.00 | 2181.56 | 4799.29 |
| Smith, Fernando,26534 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Zhou, Suzanne,12130 | 7987.91 | 0.00 | 0.00 | 3254.89 | 4733.02 |
| Andersen, Darrell,19280 | 2537.97 | 0.00 | 0.00 | 782.99 | 1754.98 |
| Diaz, Darren,16327 | 4647.88 | 0.00 | 0.00 | 4647.88 | 0.00 |
| Russell, Hailey, P,16313 | 4985.66 | 0.00 | 0.00 | 4985.66 | 0.00 |
| Ross, Taylor, S,26545 | 2822.76 | 0.00 | 0.00 | 2071.42 | 751.34 |
| Gray, Michelle,26600 | 2800.44 | 0.00 | 0.00 | 2049.10 | 751.34 |
| Garcia, Deanna, S,16297 | 6889.61 | 0.00 | 0.00 | 2181.56 | 4708.05 |
| Bryant, Cameron,15371 | 3178.95 | 0.00 | 0.00 | 782.99 | 2395.96 |
| Black, Warren,26538 | 4464.48 | 0.00 | 0.00 | 2071.42 | 2393.06 |
| Rana, Kaitlin, A,17634 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Weisman, Charles,26511 | 4464.48 | 0.00 | 0.00 | 2071.42 | 2393.06 |
| Gray, Victoria,15365 | 3142.23 | 0.00 | 0.00 | 782.99 | 2359.24 |
| Scott, Jack, A,26510 | 2813.77 | 0.00 | 0.00 | 2071.42 | 742.35 |
| Hayes, Hunter,26579 | 2840.42 | 0.00 | 0.00 | 2049.10 | 791.32 |
| White, Alyssa, L,15367 | 3177.96 | 0.00 | 0.00 | 782.99 | 2394.97 |
| Hughes, Ashley, M,14925 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Alexander, Chloe,15817 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Pal, Edwin, M,13573 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Gill, Roberto, W,14362 | 1845.90 | 0.00 | 0.00 | 1000.44 | 845.46 |
| Baker, Eric, N,24357 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Schmidt, Joel, M,22099 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Arun, Pedro,29153 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Howard, Evan, S,13700 | 4525.82 | 0.00 | 0.00 | 2181.56 | 2344.26 |
| Ramirez, Chloe,26520 | 2827.72 | 0.00 | 0.00 | 2049.10 | 778.62 |
| Alvarez, Wendy, V,12129 | 8557.41 | 0.00 | 0.00 | 2071.42 | 6485.99 |
| Wilson, Natalie, C,15394 | 3134.95 | 0.00 | 0.00 | 782.99 | 2351.96 |
| Cook, Emma, G,14117 | 3352.40 | 0.00 | 0.00 | 1000.44 | 2351.96 |
| Madan, Brett, L,28727 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Goel, Devon,14121 | 3319.70 | 0.00 | 0.00 | 1000.44 | 2319.26 |
| Sanchez, Jada,26540 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Jenkins, Abigail,15473 | 1552.48 | 0.00 | 0.00 | 782.99 | 769.49 |
| Perry, Emily, F,26649 | 4433.17 | 0.00 | 0.00 | 2049.10 | 2384.07 |
| Raman, Evelyn, W,19310 | 1611.46 | 0.00 | 0.00 | 782.99 | 828.47 |
| Torres, Jennifer, B,15472 | 1560.43 | 0.00 | 0.00 | 782.99 | 777.44 |
| Shan, Lacey, K,14957 | 2807.03 | 0.00 | 0.00 | 2181.56 | 625.47 |
| Guo, Dennis,13735 | 4516.53 | 0.00 | 0.00 | 2181.56 | 2334.97 |
| Richardson, Morgan, S,26645 | 2800.44 | 0.00 | 0.00 | 2049.10 | 751.34 |
| Sanz, Leslie, N,13180 | 201.46 | 0.00 | 0.00 | 0.00 | 201.46 |
| Henderson, Kayla,26611 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Harris, Hannah, S,26606 | 2890.41 | 0.00 | 0.00 | 2049.10 | 841.31 |
| Gutierrez, Krista, R,15071 | 2746.55 | 0.00 | 0.00 | 2181.56 | 564.99 |
| Rivera, Cole, R,13736 | 4478.84 | 0.00 | 0.00 | 2181.56 | 2297.28 |
| Harris, Jasmine,26635 | 2840.42 | 0.00 | 0.00 | 2049.10 | 791.32 |
| Thompson, Charles, J,13724 | 4476.55 | 0.00 | 0.00 | 2181.56 | 2294.99 |
| Robinson, Elizabeth,14256 | 3342.41 | 0.00 | 0.00 | 1000.44 | 2341.97 |
| Flores, Kelly, R,16414 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Sharma, Devon, C,19315 | 2537.97 | 0.00 | 0.00 | 782.99 | 1754.98 |
| Jai, Brandon,13716 | 3078.31 | 0.00 | 0.00 | 2443.35 | 634.96 |
| Lal, Damien,14948 | 2786.52 | 0.00 | 0.00 | 2181.56 | 604.96 |
| Romero, Beth,20726 | 1941.95 | 0.00 | 0.00 | 782.99 | 1158.96 |
| Hee, Stacey, M,28756 | 3218.56 | 0.00 | 0.00 | 2049.10 | 1169.46 |
| Baker, Carlos,15419 | 3102.98 | 0.00 | 0.00 | 782.99 | 2319.99 |
| Griffin, Kelly, F,15422 | 1633.94 | 0.00 | 0.00 | 782.99 | 850.95 |
| Howard, Richard, D,15428 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Perry, Alexis, S,25386 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Chen, Nathan, D,25175 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Alonso, Lawrence, S,12323 | 7258.63 | 0.00 | 0.00 | 0.00 | 7258.63 |
| Anderson, Ian, M,28860 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Murphy, Angel, M,26314 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Diaz, Dakota,15967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Harris, Fernando, R,17876 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Vazquez, Dwayne, C,12493 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Madan, Levi,15446 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Gonzalez, Mason, C,26358 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Chen, Jorge, T,20442 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 |
| Patterson, Jason,20385 | 2528.33 | 0.00 | 0.00 | 0.00 | 2528.33 |
| Hernandez, Jenna, E,26644 | 2805.43 | 0.00 | 0.00 | 2049.10 | 756.33 |
| Howard, Lucas, A,13721 | 2786.52 | 0.00 | 0.00 | 2181.56 | 604.96 |
| Zheng, Wesley,12230 | 4401.06 | 0.00 | 0.00 | 2049.10 | 2351.96 |
| Campbell, Luke,13722 | 3102.80 | 0.00 | 0.00 | 2443.35 | 659.45 |
| Kumar, Alvin, R,15432 | 1587.47 | 0.00 | 0.00 | 782.99 | 804.48 |
| Schmidt, Meagan,18183 | 3343.36 | 0.00 | 0.00 | 1000.44 | 2342.92 |
| Zhou, Franklin,28749 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Pal, Tony, S,18626 | 4644.75 | 0.00 | 0.00 | 1000.44 | 3644.31 |
| Sanchez, Eduardo,13715 | 2778.52 | 0.00 | 0.00 | 2181.56 | 596.96 |
| Luo, Jaclyn,16429 | 4958.28 | 0.00 | 0.00 | 2443.35 | 2514.93 |
| Baker, Charles,19313 | 2533.46 | 0.00 | 0.00 | 782.99 | 1750.47 |
| Roberts, Isabella,14268 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Cox, Allison, L,14335 | 1804.92 | 0.00 | 0.00 | 1000.44 | 804.48 |
| Shan, Alisha,12276 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Moreno, Rodney, I,16984 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Brown, Devin,22040 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
Generated 2025-12-24 06:46:29.076 UTC