[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SKIP 1375
132 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Robinson, Joseph,28141 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Walker, Ian,16771 | 104.55 | 0.00 | 0.00 | 54.58 | 49.97 |
| Sanchez, Stephanie,17867 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Brooks, Evan,23401 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jackson, Victoria,27019 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Harris, Joshua, L,20280 | 95.94 | 0.00 | 0.00 | 30.97 | 64.97 |
| 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 |
| Butler, Cassidy, L,21792 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Howard, Erin, L,18362 | 1725.21 | 0.00 | 0.00 | 0.00 | 1725.21 |
| Diaz, Brandon,23676 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Baker, Allison,26495 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Moore, Ian, L,24639 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Kaitlyn, B,29230 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Ramirez, Richard, C,28239 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Griffin, Seth, R,17585 | 164.46 | 0.00 | 0.00 | 78.98 | 85.48 |
| Nath, Carl, H,29001 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| Sara, Ivan, L,25090 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Ward, Destiny,16128 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Perez, Jonathan, R,23455 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Ward, Eduardo, I,13916 | 2354.98 | 0.00 | 0.00 | 0.00 | 2354.98 |
| Srini, Ruben,18078 | 200.94 | 0.00 | 0.00 | 0.00 | 200.94 |
| Edwards, Hunter,24220 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Bailey, Maria, C,19150 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Garcia, Xavier, M,20300 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Hill, Kaitlyn, M,24659 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Allen, Mason,17625 | 2431.95 | 0.00 | 0.00 | 0.00 | 2431.95 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Gonzales, Cameron, L,29005 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Martin, Katherine, J,20273 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ortega, Sheila, M,27632 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Roberts, Wyatt,15900 | 699.97 | 0.00 | 0.00 | 699.97 | 0.00 |
| Blanco, Armando, F,13918 | 2397.95 | 0.00 | 0.00 | 0.00 | 2397.95 |
| Johnson, Madison, L,15530 | 846.46 | 0.00 | 0.00 | 0.00 | 846.46 |
| Mitchell, Bailey, B,26706 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Griffin, James,28189 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Hernandez, Eduardo, J,18919 | 300.94 | 0.00 | 0.00 | 300.94 | 0.00 |
| Sanchez, Rachel, C,26730 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rogers, Paige, H,17125 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Kelly, Julia,23798 | 67.93 | 0.00 | 0.00 | 67.93 | 0.00 |
| Smith, Hannah, J,25265 | 54.98 | 0.00 | 0.00 | 54.98 | 0.00 |
| Thompson, Lucas, O,21277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jackson, Andrew,20479 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Rogers, Olivia,12020 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Lewis, Rachel, J,14900 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Li, Thomas,18116 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Gonzales, Gavin,24488 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Kumar, Cameron, S,18571 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Robinson, Lauren,27196 | 68.49 | 0.00 | 0.00 | 68.49 | 0.00 |
| Peterson, Melissa, S,24995 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Martin, Joshua, A,27607 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Wright, Kaitlyn, G,13434 | 2354.99 | 0.00 | 0.00 | 0.00 | 2354.99 |
| Johnson, Ian, E,21732 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Kapoor, Preston,21431 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Williams, Sydney, J,15334 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Cox, Sara, P,27758 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Barnes, Kayla,24256 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Jenkins, Dakota, D,20679 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Gray, Jared, A,26449 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Amber, L,23879 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Hill, Katherine, L,26701 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Adams, Katherine, M,23518 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Robinson, Zachary, L,13709 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Richardson, Brian,28608 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hill, Alexandra, K,15172 | 215.45 | 0.00 | 0.00 | 36.27 | 179.18 |
| Brooks, Jacqueline, W,28254 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Morgan, Andrea, M,16870 | 149.04 | 0.00 | 0.00 | 116.44 | 32.60 |
| James, Morgan, E,23245 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Malhotra, Gerald, A,28773 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| Rivera, Kaitlyn, R,15490 | 4813.52 | 0.00 | 0.00 | 0.00 | 4813.52 |
| Campbell, Lucas,29329 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Alexander, Caroline,17654 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Alexander, Angelica,22714 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Diaz, Faith, M,22363 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Adams, Gabriel, S,19527 | 1219.45 | 0.00 | 0.00 | 0.00 | 1219.45 |
| Adams, Carlos,19822 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Garcia, Kaitlyn, J,26310 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Thomas, Richard,27557 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Parker, Jordan,21621 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Campbell, Wyatt, C,27602 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Cox, Arianna, D,18927 | 89.25 | 0.00 | 0.00 | 0.00 | 89.25 |
| Edwards, Logan,25002 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramos, Derrick,18449 | 100.94 | 0.00 | 0.00 | 30.97 | 69.97 |
| Nelson, Sierra,16132 | 2459.62 | 0.00 | 0.00 | 2459.62 | 0.00 |
| Diaz, Hailey, W,11693 | 2294.99 | 0.00 | 0.00 | 2294.99 | 0.00 |
| Moore, Chloe, L,26269 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Harris, Samantha, A,24487 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Washington, Hailey, S,25885 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Patterson, Jocelyn, D,23559 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Henderson, Abigail,20441 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Katherine, P,11526 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Turner, Eduardo,15876 | 4789.02 | 0.00 | 0.00 | 0.00 | 4789.02 |
| Lewis, Morgan,17410 | 168.74 | 0.00 | 0.00 | 0.00 | 168.74 |
| Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
| Cannata, Gabrielle, C,21725 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Smith, Austin,13707 | 149.05 | 0.00 | 0.00 | 0.00 | 149.05 |
| Kennedy, Bridget,22026 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alexander, Jordan,21412 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Ross, Jose,27441 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Harris, Jacob, G,23679 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Russell, Rachel, C,21581 | 24.27 | 0.00 | 0.00 | 24.27 | 0.00 |
| Chen, Luis, G,21252 | 94.45 | 0.00 | 0.00 | 94.45 | 0.00 |
| Murphy, Eduardo, S,16124 | 614.45 | 0.00 | 0.00 | 0.00 | 614.45 |
| Gonzales, Arianna, S,19710 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Barnes, Dalton, C,17858 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Wilson, Eduardo,15323 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Griffin, Miguel,21464 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Martin, Jeremiah, E,17345 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Lobao, Alexandre,18926 | 91.95 | 0.00 | 0.00 | 91.95 | 0.00 |
| Peterson, Steven, L,23449 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Posti, Juha-Pekka,22219 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Wood, Brittany,28777 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Wu, Randy, J,11647 | 2365.94 | 0.00 | 0.00 | 2365.94 | 0.00 |
| Ward, Natalie, J,13241 | 2325.96 | 0.00 | 0.00 | 0.00 | 2325.96 |
| Martin, Noah, A,17657 | 75.97 | 0.00 | 0.00 | 75.97 | 0.00 |
| Taylor, Tyler, A,12032 | 614.96 | 0.00 | 0.00 | 614.96 | 0.00 |
| Sanchez, Nicole, L,14874 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Flores, Hannah,19525 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Coleman, Samuel, N,17450 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Russell, Caleb,23552 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Jones, Dalton, T,18951 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Johnson, Xavier, R,23255 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Long, Sarah,17372 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Johnson, Cameron, R,13720 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Barnes, Blake, A,17865 | 1789.97 | 0.00 | 0.00 | 0.00 | 1789.97 |
| Russell, Arianna,22728 | 149.93 | 0.00 | 0.00 | 149.93 | 0.00 |
| Hall, Grace, A,20189 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Collins, Allison,28581 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Price, Caroline,18051 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Perry, Benjamin,29165 | 2407.04 | 0.00 | 0.00 | 2407.04 | 0.00 |
| _SUM | 1806517.50 | 65197.22 | 487005.99 | 323518.76 | 930795.53 |
Generated 2025-11-04 08:40:39.573 UTC