[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 188 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hall, Fernando,22100 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Ross, Elizabeth, E,14118 | 4741.34 | 0.00 | 0.00 | 0.00 | 4741.34 |
| Richardson, Brian,28608 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gonzalez, Chelsea, E,18103 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 66.26 | 773.89 |
| Sharma, Thomas, A,18637 | 121.94 | 0.00 | 0.00 | 0.00 | 121.94 |
| Martin, John, A,14436 | 4776.01 | 0.00 | 0.00 | 0.00 | 4776.01 |
| Perry, Lauren,24816 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Russell, Jessica,26572 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Flores, Julia, E,17263 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Wright, Carol, C,12928 | 247.41 | 0.00 | 0.00 | 33.98 | 213.43 |
| White, Abigail, T,15866 | 145.82 | 0.00 | 0.00 | 38.88 | 106.94 |
| Richardson, Melissa, E,11132 | 2371.94 | 0.00 | 0.00 | 0.00 | 2371.94 |
| Gill, Robyn, J,12765 | 1750.98 | 0.00 | 0.00 | 1750.98 | 0.00 |
| Foster, Paige,27428 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Torres, Haley, W,23283 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Price, Caroline,18051 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Reed, Kaitlyn, H,27413 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Coleman, Ian,21276 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yuan, Yolanda, C,22154 | 36.96 | 0.00 | 0.00 | 36.96 | 0.00 |
| Washington, Thomas, C,27451 | 37.43 | 0.00 | 0.00 | 0.00 | 37.43 |
| Gomez, Briana, A,28784 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Johnson, Jacob, I,28069 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Watson, Marcus,22715 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Hall, Wyatt,23827 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Stewart, Jessica,16097 | 103.55 | 0.00 | 0.00 | 46.58 | 56.97 |
| Flores, Brandon, L,25621 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Thompson, Brianna, X,18642 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Parker, Eduardo, M,12939 | 169.42 | 0.00 | 0.00 | 77.92 | 91.50 |
| Wilson, Jeremy, T,28341 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Chavez, Kara, P,13285 | 214.35 | 0.00 | 0.00 | 12.94 | 201.41 |
Generated 2025-11-06 14:36:13.638 UTC