[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chapman, Kari, M,26221 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Griffin, Antonio, J,16060 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Malhotra, Shane, E,23603 | 2372.95 | 0.00 | 0.00 | 0.00 | 2372.95 |
| Moreno, Anne, A,24807 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 |
| Cox, Jan, R,26209 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| King, Sophia,16142 | 563.96 | 0.00 | 0.00 | 0.00 | 563.96 |
| Cai, Leah,18125 | 5739.50 | 0.00 | 1000.44 | 0.00 | 4739.06 |
| Gonzalez, Nancy, R,19922 | 3137.97 | 0.00 | 0.00 | 782.99 | 2354.98 |
| Hill, Natalie, L,28834 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Allen, Evan,19811 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Fernandez, Henry, A,14779 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Scott, Katherine,13380 | 4820.31 | 0.00 | 2443.35 | 0.00 | 2376.96 |
| Diaz, Victoria, C,29326 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Rivera, Danielle,26726 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Prasad, Tina, A,21869 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramirez, Carlos, M,21322 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Sharma, Lindsey,29418 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Perry, Abigail, M,25857 | 3399.99 | 3399.99 | 0.00 | 0.00 | 0.00 |
| Zheng, Shannon, M,14678 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Murphy, Timothy,14331 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Martin, Megan, A,11737 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Luo, Dawn, A,13804 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Richardson, Grace, A,17028 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Watson, Riley, A,26986 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Jones, Tyler,27446 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Howard, Marcus, C,22216 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Stone, Clayton,18434 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Russell, Brittany,18817 | 2357.28 | 0.00 | 0.00 | 0.00 | 2357.28 |
| Martinez, Allen,19386 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Goel, Kelli, V,15496 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martinez, Noah, R,25060 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Moyer, Ashlee, R,25749 | 742.35 | 0.00 | 0.00 | 742.35 | 0.00 |
| Parker, Allison,26501 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Hughes, Kevin, A,25354 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Adams, Luke, C,13265 | 3681.29 | 0.00 | 0.00 | 0.00 | 3681.29 |
| Carlson, Meghan, K,15109 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Lopez, Roy, I,26987 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Patterson, Rachel, K,14413 | 1889.91 | 0.00 | 0.00 | 1000.44 | 889.47 |
| Mitchell, Marcus,27206 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Murphy, Isabella,22645 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Rubio, Michele, L,21769 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Turner, Hailey,29279 | 4397.58 | 0.00 | 3578.27 | 0.00 | 819.31 |
| Cook, Ariana,11525 | 5935.55 | 0.00 | 3578.27 | 0.00 | 2357.28 |
| Xie, Clayton,14135 | 86.96 | 0.00 | 0.00 | 0.00 | 86.96 |
| Sanz, Roberto,12510 | 6441.02 | 0.00 | 3578.27 | 0.00 | 2862.75 |
| Foster, Natalie,15966 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Srini, Cynthia,14080 | 1848.91 | 0.00 | 0.00 | 1000.44 | 848.47 |
| Nara, Alvin, A,18354 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Nara, Alison,28364 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Torres, Armando,23241 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Patterson, Elizabeth, E,13322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Alexander, Sarah,19411 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alonso, Robyn, C,17800 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Vazquez, Kellie, B,29417 | 195.27 | 0.00 | 0.00 | 0.00 | 195.27 |
| Parker, Morgan, S,16772 | 121.57 | 0.00 | 0.00 | 0.00 | 121.57 |
| Rana, Erick, C,19679 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Jenkins, Fernando, J,21903 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Rogers, Nicole, E,22255 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Roberts, Stephanie,18373 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Lal, Adam,13877 | 3030.03 | 0.00 | 0.00 | 2181.56 | 848.47 |
| Coleman, Megan, C,24452 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Hu, Wesley, L,23088 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
Generated 2025-12-23 14:15:20.107 UTC