[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 625 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Patterson, Natalie,16123 | 629.97 | 0.00 | 0.00 | 0.00 | 629.97 |
| Hughes, Anna,19705 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Yang, Aaron, C,25196 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Ward, Jade, D,14661 | 195.02 | 0.00 | 0.00 | 0.00 | 195.02 |
| Brown, Fernando,19001 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Jackson, Elizabeth, K,16837 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Hill, Jordan, J,16005 | 198.73 | 0.00 | 0.00 | 0.00 | 198.73 |
| Nelson, Jennifer,17147 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 0.00 | 286.82 |
| 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 |
| Flores, Nathan, C,24637 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Sanders, Allison, B,18852 | 268.25 | 0.00 | 0.00 | 0.00 | 268.25 |
| Gonzalez, Jeremiah,17468 | 128.91 | 0.00 | 0.00 | 0.00 | 128.91 |
| Chen, Jonathan, G,13096 | 200.69 | 0.00 | 0.00 | 0.00 | 200.69 |
| Perry, Brandon,22095 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Miller, Eduardo,14561 | 158.84 | 0.00 | 0.00 | 49.97 | 108.87 |
| Smith, Noah,13175 | 166.92 | 0.00 | 0.00 | 0.00 | 166.92 |
| Henderson, Isabelle, K,16366 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Moore, Seth,13851 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Cox, Nathaniel, A,19661 | 2521.27 | 0.00 | 0.00 | 0.00 | 2521.27 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 0.00 | 2049.10 | 1197.45 |
| Griffin, Cassidy,26496 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Williams, Zachary, B,27099 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Evans, James, C,20665 | 4408.56 | 0.00 | 0.00 | 2049.10 | 2359.46 |
| Cox, Julia, A,20670 | 3228.57 | 0.00 | 0.00 | 2049.10 | 1179.47 |
| Diaz, Hunter, S,27242 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Taylor, Victoria,26013 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Garcia, Hunter, J,21305 | 3204.58 | 0.00 | 0.00 | 2049.10 | 1155.48 |
| Foster, Deb,21501 | 2661.40 | 0.00 | 0.00 | 2661.40 | 0.00 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Adams, Connor,21423 | 2888.56 | 0.00 | 0.00 | 2049.10 | 839.46 |
| Collins, Connor, J,27270 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Coleman, Jennifer, L,27298 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Kelly, Bryan,21349 | 2989.38 | 0.00 | 0.00 | 2989.38 | 0.00 |
| Coleman, Vanessa,21589 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Hayes, Carson, A,12447 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Cox, Devin, C,13418 | 4768.05 | 0.00 | 0.00 | 0.00 | 4768.05 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Lewis, Ryan, A,20312 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Thomas, O,16020 | 595.96 | 0.00 | 0.00 | 0.00 | 595.96 |
| Campbell, Alex,11984 | 4730.32 | 0.00 | 0.00 | 0.00 | 4730.32 |
| Patterson, Jeremy,13027 | 2319.26 | 0.00 | 0.00 | 0.00 | 2319.26 |
| Clark, Miguel, D,16987 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Sanders, Hailey,19647 | 282.04 | 0.00 | 0.00 | 0.00 | 282.04 |
| Hill, Alexandra, K,15172 | 215.45 | 0.00 | 0.00 | 36.27 | 179.18 |
| Foster, Antonio,12795 | 108.54 | 0.00 | 0.00 | 28.99 | 79.55 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 0.00 | 155.91 |
| Miller, Andrew, C,27110 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bell, Alexandria, A,13758 | 284.13 | 0.00 | 0.00 | 42.28 | 241.85 |
| Mitchell, Caleb, K,26806 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Garcia, Anna, B,15572 | 104.55 | 0.00 | 0.00 | 0.00 | 104.55 |
Generated 2025-12-21 16:55:39.815 UTC