[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chande, Mario, P,23256 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Rogers, Abigail,18815 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Taylor, Alexander, E,14588 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Williams, Brandon,20805 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Garcia, Jay,12488 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Jenkins, Alexandria, L,19841 | 604.46 | 0.00 | 0.00 | 0.00 | 604.46 |
| Alexander, Marcus, M,16102 | 563.96 | 0.00 | 0.00 | 0.00 | 563.96 |
| Brooks, Chloe, M,27103 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Nelson, Jonathan, E,18917 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Vazquez, Jay,24036 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Dominguez, Javier,12536 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Young, Dalton, R,18954 | 893.47 | 0.00 | 0.00 | 0.00 | 893.47 |
| Bradley, Erin, S,13401 | 4798.34 | 0.00 | 0.00 | 2443.35 | 2354.99 |
| Anand, Priscilla, R,17005 | 2376.45 | 0.00 | 0.00 | 0.00 | 2376.45 |
| Smith, Ian, L,17264 | 2325.96 | 0.00 | 0.00 | 0.00 | 2325.96 |
| Hu, Rosa, K,12321 | 9637.38 | 0.00 | 0.00 | 0.00 | 9637.38 |
| Phillips, Lucas,11084 | 3078.61 | 0.00 | 0.00 | 2322.28 | 756.33 |
| Parker, Andrea, L,20091 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Murphy, Abigail,27466 | 66.97 | 0.00 | 0.00 | 0.00 | 66.97 |
| Torres, Seth, A,28006 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perez, Jada,17168 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Navarro, Tanya, C,24130 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Sanz, Roberto,12510 | 6441.02 | 0.00 | 3578.27 | 0.00 | 2862.75 |
| Ortega, Desiree, A,16309 | 6910.59 | 0.00 | 0.00 | 2181.56 | 4729.03 |
| Sharma, Tommy,16532 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Chande, Darrell,11635 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Griffin, Richard,27650 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Xie, Christy, C,25089 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Butler, Jack,20486 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Subram, Bryant,24843 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Navarro, Gina, M,18002 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Collins, Bailey,11970 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Watson, Allison, H,21660 | 1134.47 | 0.00 | 0.00 | 0.00 | 1134.47 |
| Wright, Luke, H,21596 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Browning, Theodore, L,16540 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Bailey, Paige, A,18985 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Perry, Brianna, W,18230 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Patel, Tabitha, R,27931 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Barnes, Grace, R,16783 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Bennett, Caroline,17508 | 2324.92 | 0.00 | 0.00 | 0.00 | 2324.92 |
| Zhu, Glenn,22567 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Richardson, Xavier,11700 | 137.96 | 0.00 | 0.00 | 62.98 | 74.98 |
| Green, Courtney, M,14367 | 1839.92 | 0.00 | 0.00 | 1000.44 | 839.48 |
| Washington, Carol, K,13897 | 4498.53 | 0.00 | 0.00 | 2181.56 | 2316.97 |
| Anand, Tony, L,25407 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Moreno, Clinton, H,11607 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Garcia, Ebony, S,14163 | 6567.02 | 0.00 | 3578.27 | 0.00 | 2988.75 |
| Moreno, Joanna,23391 | 613.45 | 0.00 | 0.00 | 0.00 | 613.45 |
| Turner, Jordan, C,11420 | 11200.77 | 0.00 | 0.00 | 4448.38 | 6752.39 |
| Patterson, Anna,17603 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Turner, Isaiah, M,25673 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thompson, Christian, A,19815 | 597.26 | 0.00 | 0.00 | 0.00 | 597.26 |
| Henderson, Katherine, C,17421 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Williams, Hunter, J,17006 | 2404.46 | 0.00 | 0.00 | 0.00 | 2404.46 |
| Nelson, Madeline, K,26121 | 3300.25 | 0.00 | 2071.42 | 0.00 | 1228.83 |
| Taylor, Thomas,23493 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Huang, Tiffany, L,21723 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Thompson, Alyssa, K,18638 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Martin, Jessica, S,14822 | 4397.75 | 0.00 | 3578.27 | 0.00 | 819.48 |
| Hernandez, Sean, E,12232 | 4376.40 | 0.00 | 0.00 | 2071.42 | 2304.98 |
| Williams, Christian,23863 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| White, Anna,17610 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-21 16:41:35.356 UTC