[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 375 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Richardson, Arianna, C,12055 | 69.21 | 0.00 | 0.00 | 0.00 | 69.21 |
| Ross, Emma,18350 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Hernandez, Tabitha, L,19603 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| She, Tracy,21698 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Deng, Cassie, L,28385 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Torres, Stephanie,11182 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Lu, Stacey, W,11591 | 2316.97 | 0.00 | 0.00 | 0.00 | 2316.97 |
| Xie, Arturo, J,26641 | 4464.48 | 0.00 | 0.00 | 2071.42 | 2393.06 |
| Gonzales, Tristan, J,17526 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cook, Taylor,16794 | 1785.97 | 0.00 | 0.00 | 1785.97 | 0.00 |
| Alexander, Jackson,20876 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Cook, Xavier,24633 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Griffin, Jessica, A,27224 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| King, Julia, C,21278 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Robinson, Jessica,20012 | 554.97 | 0.00 | 0.00 | 0.00 | 554.97 |
| Kelly, Angela, J,20275 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Diaz, Brandi,16424 | 5738.38 | 0.00 | 0.00 | 2181.56 | 3556.82 |
| Pal, Keith, R,23399 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Kelly, Nathaniel, P,21765 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Griffin, Elizabeth, L,22137 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Weber, Lydia,23926 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Hughes, Aidan, E,28858 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Washington, Arianna, C,28009 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Mitchell, Kyle,15565 | 3099.96 | 0.00 | 0.00 | 782.99 | 2316.97 |
| Thompson, Alyssa, K,18638 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Patterson, Elijah, A,26070 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 |
| Brown, Victoria, B,19532 | 1205.47 | 0.00 | 0.00 | 1205.47 | 0.00 |
| Stewart, Brian,19426 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Ma, Alejandro, L,17187 | 3310.41 | 0.00 | 0.00 | 1000.44 | 2309.97 |
| Wilson, Blake,20195 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Chapman, Nancy, E,11276 | 148.17 | 0.00 | 0.00 | 0.00 | 148.17 |
| Zhu, Randy, B,27104 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Rubio, Neil,20953 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Perez, Madeline, E,15513 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Henderson, Ana,23388 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Harris, James, M,25064 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Lee, Joseph, F,27619 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Shan, Alisha,12276 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Alonso, Carrie,14539 | 3271.82 | 0.00 | 0.00 | 2443.35 | 828.47 |
| Evans, Devin, C,22136 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Perry, Devin,23709 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Sanz, Brandi, J,12812 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Butler, Jennifer, D,25478 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Scott, Angel, E,13245 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Flores, Kyle,18650 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Scott, Nathan, K,13887 | 4763.34 | 0.00 | 0.00 | 2443.35 | 2319.99 |
| Fernandez, Meredith,25606 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Rana, Ann, C,25793 | 2479.94 | 0.00 | 0.00 | 2479.94 | 0.00 |
| Sara, Chelsea, S,14204 | 71.58 | 0.00 | 0.00 | 71.58 | 0.00 |
| Scott, Xavier,14764 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Coleman, Jackson, S,27467 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Rodriguez, Kaitlin,21107 | 806.76 | 0.00 | 0.00 | 0.00 | 806.76 |
| Jones, Christian, S,18423 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Price, Jennifer, J,24339 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Zhao, Claudia, E,22633 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Butler, Richard, C,17593 | 2380.47 | 0.00 | 0.00 | 0.00 | 2380.47 |
| Allen, Samuel, W,13917 | 3282.81 | 0.00 | 0.00 | 2443.35 | 839.46 |
| Simmons, Jasmine, D,26647 | 2889.94 | 0.00 | 0.00 | 2049.10 | 840.84 |
| Zhang, Alisha, G,28394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Mitchell, Kevin,23352 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Ross, Isabel,27379 | 152.47 | 0.00 | 0.00 | 0.00 | 152.47 |
| Cox, Savannah, A,15819 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
Generated 2025-12-18 02:27:34.504 UTC