[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1001 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Rodriguez, Alexis, L,15244 | 179.19 | 0.00 | 0.00 | 0.00 | 179.19 |
| Johnson, Jeremiah, A,14446 | 146.75 | 0.00 | 0.00 | 14.98 | 131.77 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Williams, Zachary, B,27099 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Cooper, Christina, C,26512 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Robinson, Jennifer, L,26504 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| White, Christopher, R,26049 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Coleman, Jennifer, L,27298 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ward, Juan, H,21595 | 2649.56 | 0.00 | 0.00 | 2049.10 | 600.46 |
| Hall, Fernando,22100 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Harrison, Trevor, A,18055 | 143.91 | 0.00 | 0.00 | 0.00 | 143.91 |
| Edwards, Mackenzie, K,23458 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Stewart, Grace, H,24773 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Flores, Brittany,16906 | 2359.98 | 0.00 | 0.00 | 0.00 | 2359.98 |
| Green, Chloe, J,14658 | 92.82 | 0.00 | 0.00 | 0.00 | 92.82 |
| Simmons, Elizabeth, A,21461 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Patterson, Jeremy,13027 | 2319.26 | 0.00 | 0.00 | 0.00 | 2319.26 |
| Ross, Alexia, S,13231 | 247.90 | 0.00 | 0.00 | 0.00 | 247.90 |
| Brown, Jonathan,11875 | 265.42 | 0.00 | 0.00 | 0.00 | 265.42 |
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 0.00 | 111.89 |
| Foster, Trevor, J,28964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alexander, Jason,29328 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Diaz, Jasmine, A,16098 | 3101.29 | 0.00 | 0.00 | 756.33 | 2344.96 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Carter, Elijah,21618 | 2611.07 | 0.00 | 0.00 | 2611.07 | 0.00 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Garcia, Lucas,27545 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ramirez, Sydney,26700 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 0.00 | 87.95 |
| Green, Gabriella, C,28035 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Smith, Alexandra,28292 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Cox, Katelyn, B,21742 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Rivera, Ariana,26173 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Coleman, Joan, W,26699 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Thompson, Blake,18390 | 141.96 | 0.00 | 0.00 | 0.00 | 141.96 |
| Martin, Samuel,15874 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Wright, Carol, C,12928 | 247.41 | 0.00 | 0.00 | 0.00 | 247.41 |
| Ross, Elizabeth, E,14118 | 4741.34 | 0.00 | 0.00 | 0.00 | 4741.34 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Sanchez, Faith,27049 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nelson, Sierra,16132 | 2459.62 | 0.00 | 0.00 | 2459.62 | 0.00 |
| Simmons, Brittany,29231 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alexander, Lauren,18950 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Lewis, Ryan, A,20312 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Victoria,17551 | 160.92 | 0.00 | 0.00 | 0.00 | 160.92 |
| Perry, Justin, E,16758 | 3062.34 | 0.00 | 0.00 | 0.00 | 3062.34 |
| Harris, Samantha, A,24487 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Nicholas,23362 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Stewart, Sara,17347 | 119.72 | 0.00 | 0.00 | 0.00 | 119.72 |
| Edwards, Madeline,20771 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Thomas, Benjamin, J,21295 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Rodriguez, Taylor,16071 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Perez, Kaitlyn, A,12081 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
Generated 2025-12-23 11:32:24.034 UTC