[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 250 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Perry, Oscar,22785 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Lee, Emma,16948 | 176.43 | 0.00 | 0.00 | 0.00 | 176.43 |
| Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
| White, Christopher, R,26049 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Sanchez, Allison,16667 | 41.72 | 0.00 | 0.00 | 0.00 | 41.72 |
| Johnson, Christopher,11979 | 4813.76 | 0.00 | 0.00 | 2352.21 | 2461.55 |
| Perry, Benjamin,29165 | 2407.04 | 0.00 | 0.00 | 2407.04 | 0.00 |
| Russell, Arianna,22728 | 149.93 | 0.00 | 0.00 | 149.93 | 0.00 |
| Evans, Dalton, E,12710 | 4774.04 | 0.00 | 0.00 | 2354.98 | 2419.06 |
| Hall, Taylor, J,16995 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 118.96 | 533.02 |
| Chen, Jackson, S,27075 | 1371.95 | 0.00 | 782.99 | 0.00 | 588.96 |
| Miller, Eduardo,14561 | 158.84 | 0.00 | 0.00 | 49.97 | 108.87 |
| Moore, Jennifer, A,21759 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Hayes, Luis,12880 | 200.73 | 0.00 | 0.00 | 0.00 | 200.73 |
| Coleman, Ashley,27297 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Moore, Taylor, A,19987 | 4564.45 | 0.00 | 3374.99 | 0.00 | 1189.46 |
| Jones, Alexandra, B,20202 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Coleman, Jose, S,25349 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Young, Julia, J,27414 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Long, Sarah,17372 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 0.00 | 213.52 |
| Simmons, James,19884 | 4588.45 | 0.00 | 3399.99 | 0.00 | 1188.46 |
| Li, Rafael, M,21752 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Mehta, Carmen, C,27436 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Sanders, Megan, A,15376 | 136.24 | 0.00 | 0.00 | 0.00 | 136.24 |
| Washington, Thomas, C,27451 | 37.43 | 0.00 | 0.00 | 0.00 | 37.43 |
| Hughes, Destiny, P,28027 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Gonzalez, Amber, L,23879 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Harris, Natalie,23682 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 0.00 | 4745.02 |
| Wang, Benjamin, R,27454 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Howard, Brianna, D,24630 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 84.96 | 70.95 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Sara, Ivan, L,25090 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Powell, Elijah, E,23113 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Suarez, Juan, R,16763 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Price, Lauren, J,14079 | 184.74 | 0.00 | 0.00 | 37.29 | 147.45 |
| Alexander, Elijah,11738 | 331.68 | 0.00 | 0.00 | 141.73 | 189.95 |
| Ramirez, Jennifer, E,21311 | 4472.58 | 0.00 | 0.00 | 2049.10 | 2423.48 |
| Prasad, Erick, E,28786 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| Diaz, Ryan, J,16910 | 141.96 | 0.00 | 0.00 | 71.97 | 69.99 |
| Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 96.07 | 65.21 |
| Diaz, Alyssa,13908 | 4715.33 | 0.00 | 0.00 | 0.00 | 4715.33 |
| Peterson, Steven, L,23449 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Torres, Pedro, E,16958 | 168.02 | 0.00 | 0.00 | 153.04 | 14.98 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 99.97 | 126.46 |
| Cox, Sara, P,27758 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Green, Sophia, E,24977 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Roberts, Amanda,17175 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Phillips, Mackenzie,12444 | 228.43 | 0.00 | 0.00 | 113.96 | 114.47 |
| Washington, Aaron, L,24649 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rivera, Ariana,26173 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Watson, Marcus,22715 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Watson, Janet, S,23208 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Coleman, Miguel, D,27400 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Turner, Wyatt,20034 | 5769.96 | 0.00 | 3399.99 | 0.00 | 2369.97 |
Generated 2025-11-02 04:55:28.244 UTC