[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 125 > TITLE Top 1000 Australian Internet customers for 2020
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Price, Lauren, J,14079 | 184.74 | 0.00 | 0.00 | 115.77 | 68.97 |
| Ma, Tiffany,21577 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yuan, Yolanda, C,22154 | 36.96 | 0.00 | 0.00 | 36.96 | 0.00 |
| Rubio, Ruben, D,18871 | 86.96 | 0.00 | 0.00 | 86.96 | 0.00 |
| Bell, Alexandria, A,13758 | 284.13 | 0.00 | 0.00 | 237.87 | 46.26 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 99.53 | 71.94 |
| Alexander, Jordan,21412 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Rodriguez, Nicholas, D,14604 | 137.95 | 0.00 | 0.00 | 137.95 | 0.00 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 330.95 | 668.27 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 693.99 | 412.69 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 790.61 | 515.05 |
| Martinez, Andrew, C,11530 | 523.81 | 0.00 | 0.00 | 327.08 | 196.73 |
| Howard, Brianna, D,24630 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Reed, Kaitlyn, H,27413 | 103.48 | 0.00 | 0.00 | 103.48 | 0.00 |
| Peterson, Julia, P,16497 | 132.71 | 0.00 | 0.00 | 48.96 | 83.75 |
| Gonzales, Nathan, M,12107 | 222.23 | 0.00 | 0.00 | 187.25 | 34.98 |
| Collins, Jonathan,16849 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Patterson, Eduardo,11142 | 866.81 | 0.00 | 0.00 | 229.70 | 637.11 |
| Flores, Luke, L,24733 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Phillips, Kaylee,21138 | 4371.38 | 0.00 | 0.00 | 2049.10 | 2322.28 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 2049.10 | 0.00 | 1120.49 |
| Rivera, Amanda,11131 | 115.92 | 0.00 | 0.00 | 0.00 | 115.92 |
| Sharma, Jackson,16876 | 151.84 | 0.00 | 0.00 | 34.89 | 116.95 |
| Thomas, Dalton,23009 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hughes, Morgan, T,11642 | 392.89 | 0.00 | 0.00 | 193.93 | 198.96 |
| Turner, Samuel,27420 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Hall, Jose, J,17601 | 225.42 | 0.00 | 0.00 | 225.42 | 0.00 |
| Phillips, Isaiah,28631 | 144.47 | 0.00 | 0.00 | 144.47 | 0.00 |
| Bell, Timothy, J,28101 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Ward, Kaylee, A,24415 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 155.22 | 496.76 |
| Moreno, Lance, A,29229 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Brooks, Steven, C,14877 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
| Morgan, Jada, A,11520 | 702.99 | 0.00 | 0.00 | 425.30 | 277.69 |
| Smith, Austin,13707 | 149.05 | 0.00 | 0.00 | 0.00 | 149.05 |
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 74.98 | 36.91 |
| Gutierrez, Neil, L,21489 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanchez, Nicole, L,14874 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 350.91 | 1030.46 |
| Roberts, Amanda,17175 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Morgan, Andrea, M,16870 | 149.04 | 0.00 | 0.00 | 149.04 | 0.00 |
| Lewis, Lucas, A,23209 | 4802.11 | 0.00 | 3578.27 | 1223.84 | 0.00 |
| Peterson, Steven, L,23449 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Diaz, Ryan, J,16910 | 141.96 | 0.00 | 0.00 | 71.97 | 69.99 |
| Peterson, Brian,12892 | 419.47 | 0.00 | 0.00 | 156.27 | 263.20 |
| Hughes, Nathan, B,12113 | 4737.53 | 0.00 | 0.00 | 4737.53 | 0.00 |
| Ashe, Alexis, S,19414 | 1145.48 | 0.00 | 0.00 | 1145.48 | 0.00 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 626.65 | 220.12 |
| Russell, Chloe, M,12763 | 589.96 | 0.00 | 0.00 | 589.96 | 0.00 |
| Powell, Miranda, J,15304 | 4843.00 | 0.00 | 0.00 | 2369.96 | 2473.04 |
| Ruiz, Carrie, D,18644 | 135.44 | 0.00 | 0.00 | 135.44 | 0.00 |
| Martin, Gina, E,11078 | 793.27 | 0.00 | 0.00 | 480.26 | 313.01 |
| Martinez, Joseph, E,29214 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Taylor, Lucas, V,11523 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Anderson, David, A,22097 | 61.96 | 0.00 | 0.00 | 61.96 | 0.00 |
| Rodriguez, Taylor,16071 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 81.46 | 37.27 |
| Brooks, Evan,23401 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Butler, Isabel,16241 | 126.96 | 0.00 | 0.00 | 56.97 | 69.99 |
| Jackson, Victoria,27019 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Stewart, Amanda, M,15310 | 94.44 | 0.00 | 0.00 | 59.55 | 34.89 |
| Perry, Justin, E,16758 | 3062.34 | 0.00 | 0.00 | 742.35 | 2319.99 |
| Sara, Ivan, L,25090 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Ward, Jade, D,14661 | 195.02 | 0.00 | 0.00 | 171.05 | 23.97 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Ramirez, Makayla, L,17509 | 98.72 | 0.00 | 0.00 | 37.27 | 61.45 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 104.96 | 120.48 |
| McDonald, Aaron, J,27734 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Diaz, Luis, D,11203 | 801.77 | 0.00 | 0.00 | 469.77 | 332.00 |
| Bailey, Olivia,23892 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Hughes, Riley,29284 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Ramos, Kristi,15176 | 4703.03 | 0.00 | 0.00 | 2309.97 | 2393.06 |
| Ramos, Derrick,18449 | 100.94 | 0.00 | 0.00 | 100.94 | 0.00 |
| Morris, Jessica,28967 | 8.99 | 0.00 | 0.00 | 8.99 | 0.00 |
| Collins, Sierra,18549 | 1169.46 | 0.00 | 0.00 | 1169.46 | 0.00 |
| Adams, Connor,21423 | 2888.56 | 0.00 | 0.00 | 2049.10 | 839.46 |
| Wilson, Daniel, K,14281 | 4746.30 | 0.00 | 0.00 | 2325.96 | 2420.34 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 64.97 | 148.55 |
| Baker, Allison,26495 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Young, Courtney,17622 | 2374.98 | 0.00 | 0.00 | 0.00 | 2374.98 |
| Richardson, Arianna, C,12055 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Green, Marcus, C,15974 | 208.41 | 0.00 | 0.00 | 91.95 | 116.46 |
| Phillips, James, G,16846 | 180.95 | 0.00 | 0.00 | 180.95 | 0.00 |
| Perry, Samuel,18811 | 100.96 | 0.00 | 0.00 | 100.96 | 0.00 |
| Johnson, Xavier, R,23255 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Foster, Emma,15468 | 436.35 | 0.00 | 0.00 | 159.99 | 276.36 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 76.95 | 93.96 |
| Prasad, Donald,15413 | 318.92 | 0.00 | 0.00 | 198.96 | 119.96 |
| Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 54.95 | 76.59 |
| Gonzalez, Morgan,13065 | 1700.99 | 0.00 | 0.00 | 1700.99 | 0.00 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 139.96 | 168.01 |
| Allen, Allison, A,19757 | 37.27 | 0.00 | 0.00 | 32.28 | 4.99 |
| Scott, Adam,15863 | 243.01 | 0.00 | 0.00 | 171.43 | 71.58 |
| Flores, Gabriel,27111 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Tang, Carl,21238 | 32.27 | 0.00 | 0.00 | 32.27 | 0.00 |
| Mehta, Rebekah, B,27419 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Gonzales, Ashley, C,18600 | 51.97 | 0.00 | 0.00 | 21.98 | 29.99 |
| Ward, Destiny,16128 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Alexander, Aidan,17387 | 148.19 | 0.00 | 0.00 | 148.19 | 0.00 |
| Rogers, Sean, G,18685 | 124.46 | 0.00 | 0.00 | 0.00 | 124.46 |
| Yang, Justin, S,15363 | 4719.04 | 0.00 | 0.00 | 2334.97 | 2384.07 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
| Gray, Sebastian, B,13878 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 471.29 | 654.07 |
| Walker, Jacob, N,29027 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Torres, Pedro, E,16958 | 168.02 | 0.00 | 0.00 | 168.02 | 0.00 |
| Coleman, Stephanie,22264 | 89.97 | 0.00 | 0.00 | 89.97 | 0.00 |
| Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 369.40 | 354.16 |
| Brown, Dylan, J,12449 | 2351.96 | 0.00 | 0.00 | 2351.96 | 0.00 |
| Jones, Nicole,14504 | 112.27 | 0.00 | 0.00 | 0.00 | 112.27 |
| Brown, Anthony, J,19399 | 151.43 | 0.00 | 0.00 | 151.43 | 0.00 |
| Butler, Victoria,13284 | 4767.53 | 0.00 | 0.00 | 4767.53 | 0.00 |
| Simmons, Mariah,26683 | 1270.82 | 699.10 | 0.00 | 0.00 | 571.72 |
| Morris, Abigail, C,28776 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Flores, Emma, P,15543 | 180.94 | 0.00 | 0.00 | 78.98 | 101.96 |
| Dominguez, Meghan,14370 | 122.56 | 0.00 | 0.00 | 0.00 | 122.56 |
| Scott, Mason,23551 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Davis, Nicholas,13201 | 73.16 | 0.00 | 0.00 | 0.00 | 73.16 |
| Lee, Kayla, M,20781 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Rogers, Carlos,19645 | 134.44 | 0.00 | 0.00 | 134.44 | 0.00 |
| Sanders, Mason, G,23459 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Emily,13206 | 163.19 | 0.00 | 0.00 | 69.97 | 93.22 |
| Edwards, Alexandra,13358 | 2386.94 | 0.00 | 0.00 | 0.00 | 2386.94 |
| Ross, Natalie, J,12916 | 261.22 | 0.00 | 0.00 | 68.97 | 192.25 |
Generated 2026-07-21 13:33:37.688 UTC