[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1374 > < TAKE 248 >
133 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sharma, Thomas, A,18637 | 121.94 | 0.00 | 0.00 | 0.00 | 121.94 |
| Sanchez, Grace,12080 | 2354.99 | 0.00 | 0.00 | 0.00 | 2354.99 |
| Johnson, Jonathan,22059 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hall, Morgan,21726 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Sanchez, Martin, E,21631 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Taylor, Marcus, A,18944 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Morris, Abigail, C,28776 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Dominguez, Meghan,14370 | 122.56 | 0.00 | 0.00 | 0.00 | 122.56 |
| Campbell, Hunter,17422 | 174.92 | 0.00 | 0.00 | 0.00 | 174.92 |
| Kumar, Elijah,15197 | 156.92 | 0.00 | 0.00 | 0.00 | 156.92 |
| Miller, Jill,12914 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Taylor, Ryan,17025 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Mr., Sandstone, John, J,12903 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Carter, Sydney,12959 | 203.92 | 0.00 | 0.00 | 0.00 | 203.92 |
| Bell, Brooke, H,23253 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Coleman, Alexandria, C,13289 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Wilson, Hunter, R,27230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Lewis, Morgan,17410 | 168.74 | 0.00 | 0.00 | 0.00 | 168.74 |
| Rogers, Jared, J,12166 | 162.22 | 0.00 | 0.00 | 0.00 | 162.22 |
| Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
| Rogers, Sean, G,18685 | 124.46 | 0.00 | 0.00 | 0.00 | 124.46 |
| Morris, Richard,20070 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Madan, Carmen, V,15567 | 4720.27 | 0.00 | 0.00 | 0.00 | 4720.27 |
| Long, Xavier,11251 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Washington, Elijah, L,25016 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Powell, Lauren, E,19662 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Ortega, Javier, P,12785 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Gutierrez, Jerome,12783 | 2420.46 | 0.00 | 0.00 | 0.00 | 2420.46 |
| Brown, Samantha, G,25147 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Thomas, C,27451 | 37.43 | 0.00 | 0.00 | 0.00 | 37.43 |
| Martinez, Matthew, L,16009 | 170.45 | 0.00 | 0.00 | 0.00 | 170.45 |
| Rogers, Faith,24682 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Hughes, Miranda,26678 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Brooks, Jennifer, L,17411 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Robinson, Abigail, R,18379 | 2362.27 | 0.00 | 0.00 | 0.00 | 2362.27 |
| Hernandez, Marcus,18595 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Nelson, Jennifer,17147 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Collins, Alex, S,28781 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Bryant, Brittany,22545 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Garcia, Isabella,18382 | 204.94 | 0.00 | 0.00 | 0.00 | 204.94 |
| Johnson, Edward, H,23279 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Washington, Robert, J,14906 | 143.95 | 0.00 | 0.00 | 0.00 | 143.95 |
| Flores, Brittany,16906 | 2359.98 | 0.00 | 0.00 | 0.00 | 2359.98 |
| Perry, Natalie,17126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mitchell, Caleb, K,26806 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Richard, A,26682 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Bryant, Nathan,21450 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Harris, Destiny, M,13710 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Simmons, Jose,24647 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Morgan, Marcus, W,28968 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Ward, Emma, W,21796 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Alexander, Edward, E,18524 | 195.95 | 0.00 | 0.00 | 0.00 | 195.95 |
| Gray, Mackenzie, L,17680 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Jones, Charles,22882 | 101.45 | 0.00 | 0.00 | 0.00 | 101.45 |
| White, Greg, C,17403 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Perez, Timothy, L,22730 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Jeremiah, E,17345 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Griffin, Marcus,20756 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Thompson, Xavier, R,15761 | 192.41 | 0.00 | 0.00 | 0.00 | 192.41 |
| Hughes, Anna,19705 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Zhang, Nathan, L,29104 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| 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 |
| Brown, Julia,18065 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Brooks, Steven, C,14877 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
| Gutierrez, Linda, D,28575 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Edwards, Madeline,20771 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Roberts, Amanda,17175 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Flores, Nathan, C,24637 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Flores, Hannah,19525 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Bradley, Alexandria,17691 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
| Sanchez, Stephanie,17867 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Wilson, Emily,17400 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Johnson, Cameron, R,13720 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Evans, Gabriel,23487 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Sanders, Zoe, L,24825 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Baker, Allison,26495 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Luo, Jodi,29213 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Anderson, Ryan, W,13271 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| James, Bryce,13466 | 133.45 | 0.00 | 0.00 | 0.00 | 133.45 |
| Richardson, Brian,28608 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Alexander, Julian,13217 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Sanders, Mason, G,23459 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Edwards, Alexandra,13358 | 2386.94 | 0.00 | 0.00 | 0.00 | 2386.94 |
| Campbell, Lucas,29329 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Alexander, Julia, J,15291 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
| Coleman, Dylan,27403 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Young, Jenna, W,16365 | 2490.18 | 0.00 | 0.00 | 0.00 | 2490.18 |
| Baker, Gabriella,17404 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Wood, Gabrielle, S,28787 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Peterson, Xavier, R,26456 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wilson, Eduardo,15323 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Russell, Nicole, M,18237 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Posti, Juha-Pekka,22219 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Collins, Amanda,20783 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ross, Kaitlyn,16121 | 614.47 | 0.00 | 0.00 | 0.00 | 614.47 |
| Rivera, Amanda,11131 | 115.92 | 0.00 | 0.00 | 0.00 | 115.92 |
| Malhotra, Brenda,13391 | 2405.47 | 0.00 | 0.00 | 0.00 | 2405.47 |
| Reed, Melanie, A,28160 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Robinson, Ian, D,13852 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Peterson, Kaitlyn, S,13706 | 2337.27 | 0.00 | 0.00 | 0.00 | 2337.27 |
| Barnes, Blake, A,17865 | 1789.97 | 0.00 | 0.00 | 0.00 | 1789.97 |
| Gonzales, Melanie, C,18089 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Howard, Erin, L,18362 | 1725.21 | 0.00 | 0.00 | 0.00 | 1725.21 |
| Robinson, Madison, W,18377 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 |
| Foster, Isabelle,26377 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Price, Caroline,18051 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Baker, Eduardo,18092 | 1789.45 | 0.00 | 0.00 | 0.00 | 1789.45 |
| Perez, Katherine, J,22079 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Hall, Jason, A,29351 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Coleman, Ian,21276 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jackson, Andrew,20479 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Li, Thomas,18116 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Stewart, Gabriella,28034 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Flores, Luke, L,24733 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martin, Kellie, R,28195 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| White, Emma, N,16090 | 604.96 | 0.00 | 0.00 | 0.00 | 604.96 |
| Srini, Evelyn,16855 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Sara, Ivan, L,25090 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Gonzalez, Chelsea, E,18103 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Zhang, Connor, R,13853 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Moore, Jennifer, A,21759 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Johnson, Madison, L,15530 | 846.46 | 0.00 | 0.00 | 0.00 | 846.46 |
| Gomez, Briana, A,28784 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Gonzales, Gavin,24488 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ramirez, Emma,29072 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Campbell, Timothy,25845 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Williams, Joshua,26051 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| _SUM | 1806517.50 | 25543.71 | 492798.22 | 255388.12 | 1032787.45 |
Generated 2025-12-24 06:38:28.451 UTC