[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 125 > TITLE Top 1000 Australian Internet customers for 2020
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Blanco, Albert, W,13581 | 8374.79 | 3578.27 | 0.00 | 0.00 | 4796.52 |
| Liang, Cedric, R,19941 | 3078.06 | 699.10 | 0.00 | 0.00 | 2378.96 |
| Morris, Savannah,13585 | 8368.29 | 3578.27 | 0.00 | 0.00 | 4790.02 |
| Sara, Andre, M,13661 | 5913.24 | 3578.27 | 0.00 | 0.00 | 2334.97 |
| Coleman, Alexis, M,11244 | 7175.75 | 3399.99 | 0.00 | 3166.31 | 609.45 |
| Watson, Jan, K,13680 | 5948.24 | 3578.27 | 0.00 | 0.00 | 2369.97 |
| Bailey, Ariana, J,13691 | 5976.74 | 3578.27 | 0.00 | 0.00 | 2398.47 |
| Hernandez, Anne, B,11240 | 7586.23 | 3399.99 | 0.00 | 2369.96 | 1816.28 |
| Brown, Nicole,11334 | 8154.02 | 3399.99 | 0.00 | 2334.97 | 2419.06 |
| Romero, Jerome,11337 | 8162.00 | 3374.99 | 0.00 | 2388.96 | 2398.05 |
| Ruiz, Theodore,20052 | 3214.03 | 699.10 | 0.00 | 2514.93 | 0.00 |
| Tang, Kurt, G,13847 | 5888.24 | 3578.27 | 0.00 | 0.00 | 2309.97 |
| Miller, Emily, R,11333 | 8163.31 | 3399.99 | 0.00 | 2344.26 | 2419.06 |
| Perez, Manuel, C,13777 | 7147.07 | 3578.27 | 0.00 | 0.00 | 3568.80 |
| Martin, Mallory, J,13794 | 7212.06 | 0.00 | 3578.27 | 0.00 | 3633.79 |
| Moreno, Craig, N,14158 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Munoz, Billy, J,14150 | 6705.59 | 0.00 | 3578.27 | 777.34 | 2349.98 |
| Martin, Derrick,14191 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Sara, Toni, E,14146 | 6750.56 | 0.00 | 3578.27 | 827.33 | 2344.96 |
| Gray, Natalie, L,14165 | 5910.55 | 0.00 | 3578.27 | 0.00 | 2332.28 |
| Blanco, Clinton, J,14195 | 8316.29 | 0.00 | 3578.27 | 0.00 | 4738.02 |
| Zimmerman, Curtis, T,14702 | 6729.57 | 0.00 | 3578.27 | 777.34 | 2373.96 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Nath, Clayton,14793 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Ramos, Anne, R,11351 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| Raman, Meredith,11381 | 8161.02 | 0.00 | 3399.99 | 2341.97 | 2419.06 |
| Vazquez, Lee,14843 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Zhao, Dennis,20173 | 3181.33 | 0.00 | 699.10 | 0.00 | 2482.23 |
| Arthur, Ronald, D,14776 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Chen, Alejandro,14947 | 6658.58 | 0.00 | 3578.27 | 0.00 | 3080.31 |
| Martin, Joseph,11388 | 6986.75 | 0.00 | 3374.99 | 2342.92 | 1268.84 |
| Nath, Colin, N,11398 | 8114.04 | 0.00 | 3399.99 | 2294.99 | 2419.06 |
| Stewart, Brianna, L,20558 | 3019.09 | 0.00 | 699.10 | 0.00 | 2319.99 |
| Scott, Dalton,14975 | 5957.22 | 0.00 | 3578.27 | 0.00 | 2378.95 |
| Tang, Casey,15046 | 5943.25 | 0.00 | 3578.27 | 0.00 | 2364.98 |
| Patel, Roy, A,14928 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Munoz, Daisy,15081 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Liu, Willie,20561 | 3139.09 | 0.00 | 699.10 | 0.00 | 2439.99 |
| Lopez, Dominique, S,15077 | 6673.53 | 0.00 | 3578.27 | 0.00 | 3095.26 |
| Suarez, Julio, J,15058 | 6639.58 | 0.00 | 3578.27 | 0.00 | 3061.31 |
| Dominguez, Jessie, A,25628 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Shan, Misty,20868 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Jenkins, Caleb,14184 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Taylor, Joseph, T,12289 | 5645.86 | 0.00 | 0.00 | 2049.10 | 3596.76 |
| Raji, Mario,28695 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Raman, Joe, G,16511 | 47.26 | 0.00 | 0.00 | 39.98 | 7.28 |
| Sharma, James, L,21049 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Hu, Lisa, L,21118 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| McDonald, Jenny,16543 | 53.96 | 0.00 | 0.00 | 0.00 | 53.96 |
| Raji, Nina, W,29480 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Gao, Jessie,20564 | 3059.08 | 0.00 | 699.10 | 0.00 | 2359.98 |
| Sanz, Robin, L,15087 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Prasad, Martin,15089 | 5895.24 | 0.00 | 3578.27 | 0.00 | 2316.97 |
| Navarro, Shannon, R,15106 | 8421.28 | 0.00 | 3578.27 | 0.00 | 4843.01 |
| Subram, Levi,15619 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 2359.46 | 2393.06 |
| Perez, Andre,11491 | 8158.01 | 0.00 | 3374.99 | 2329.98 | 2453.04 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Robinson, Brandon, J,15661 | 5208.04 | 0.00 | 3578.27 | 0.00 | 1629.77 |
| Henderson, Julian, J,15691 | 8341.29 | 0.00 | 3578.27 | 0.00 | 4763.02 |
| Luo, Calvin, T,19172 | 1609.41 | 0.00 | 1000.44 | 0.00 | 608.97 |
| Sanchez, Edgar,11604 | 6786.12 | 0.00 | 2049.10 | 2343.96 | 2393.06 |
| Lin, Erica, E,16033 | 3743.39 | 0.00 | 2181.56 | 0.00 | 1561.83 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 2319.99 | 2398.05 |
| Torres, Deb,11550 | 5241.43 | 0.00 | 2049.10 | 3192.33 | 0.00 |
| Perez, Frederick,16053 | 3752.38 | 0.00 | 2181.56 | 0.00 | 1570.82 |
| Beck, Carl, M,16311 | 2988.32 | 0.00 | 2181.56 | 806.76 | 0.00 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 2181.56 | 928.49 | 0.00 |
| Xie, Colleen, C,12133 | 5830.68 | 0.00 | 2071.42 | 2441.93 | 1317.33 |
| Raje, Brendan,16250 | 4511.54 | 0.00 | 2181.56 | 0.00 | 2329.98 |
| Huang, Colin,20712 | 3261.33 | 0.00 | 782.99 | 0.00 | 2478.34 |
| Bryant, Noah,16417 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Navarro, Joy,16410 | 3242.77 | 0.00 | 2443.35 | 0.00 | 799.42 |
| Ruiz, Erika, J,19192 | 1682.41 | 0.00 | 1000.44 | 0.00 | 681.97 |
| Raje, Julie, H,12214 | 6803.92 | 0.00 | 2049.10 | 0.00 | 4754.82 |
| Munoz, Kristine,16446 | 3093.03 | 0.00 | 2181.56 | 0.00 | 911.47 |
| Kapoor, Brenda, C,20834 | 2566.95 | 0.00 | 782.99 | 1783.96 | 0.00 |
| Ross, Ryan,16428 | 3021.02 | 0.00 | 2181.56 | 0.00 | 839.46 |
| Lopez, Courtney,20839 | 2511.26 | 0.00 | 0.00 | 2511.26 | 0.00 |
| Beck, Cristina, J,12284 | 5625.25 | 0.00 | 0.00 | 3295.26 | 2329.99 |
| Jones, Chloe,20838 | 2541.94 | 0.00 | 0.00 | 2541.94 | 0.00 |
| Liu, Vincent,20848 | 2558.46 | 0.00 | 0.00 | 2558.46 | 0.00 |
| Sanz, Frank, T,20851 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Hu, Micah, A,16541 | 3028.02 | 0.00 | 0.00 | 2181.56 | 846.46 |
| Martinez, Andre,16588 | 6994.58 | 0.00 | 0.00 | 2181.56 | 4813.02 |
| Lal, Wayne, C,16829 | 7185.37 | 0.00 | 0.00 | 2443.35 | 4742.02 |
| Serrano, Walter, G,12299 | 4977.36 | 0.00 | 0.00 | 4428.38 | 548.98 |
| Kumar, Nicolas, R,12292 | 5027.86 | 0.00 | 0.00 | 4464.09 | 563.77 |
| Rai, Kate,16598 | 7131.40 | 0.00 | 0.00 | 2443.35 | 4688.05 |
| Vazquez, Theodore, T,16831 | 7206.37 | 0.00 | 0.00 | 2443.35 | 4763.02 |
| Howard, Grace, J,20864 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Chen, Dennis, M,17627 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Harrison, Reginald, M,23774 | 1234.45 | 0.00 | 0.00 | 0.00 | 1234.45 |
| Wu, Jaclyn,24035 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Rana, Marie, A,27308 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Roberts, Gabrielle, E,29432 | 1307.31 | 0.00 | 0.00 | 0.00 | 1307.31 |
| Sun, Heather,28729 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Raman, Tammy,12126 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Serrano, Jonathon, F,23954 | 1178.45 | 0.00 | 0.00 | 0.00 | 1178.45 |
| Sun, Stacey, S,19361 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Zhao, Eugene,12328 | 6792.11 | 0.00 | 0.00 | 6792.11 | 0.00 |
| Moreno, Albert,12402 | 5218.40 | 0.00 | 0.00 | 2049.10 | 3169.30 |
| Raje, Christine, W,17203 | 6952.53 | 0.00 | 0.00 | 2181.56 | 4770.97 |
| Carlson, Craig, G,17218 | 6907.56 | 0.00 | 0.00 | 2181.56 | 4726.00 |
| Hernandez, Joanna,19360 | 3511.76 | 0.00 | 0.00 | 3511.76 | 0.00 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Martinez, Deanna,17202 | 6974.06 | 0.00 | 0.00 | 2181.56 | 4792.50 |
| Torres, Hector, E,17700 | 2805.53 | 0.00 | 0.00 | 2805.53 | 0.00 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Raman, Bruce,20886 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Huang, Todd,12463 | 5202.22 | 0.00 | 0.00 | 2071.42 | 3130.80 |
| Pal, Rafael, J,17715 | 2831.53 | 0.00 | 0.00 | 2831.53 | 0.00 |
| Cox, Zoe, A,17755 | 2768.53 | 0.00 | 0.00 | 2181.56 | 586.97 |
| Miller, Nathan, l,19418 | 3476.39 | 0.00 | 0.00 | 3476.39 | 0.00 |
| Washington, Isabella,20880 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Shan, Jerry,19382 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Xie, Franklin, A,17747 | 2743.53 | 0.00 | 0.00 | 2181.56 | 561.97 |
| Wagner, Clayton, L,20922 | 3226.34 | 0.00 | 0.00 | 782.99 | 2443.35 |
| Ma, Ronnie, C,17815 | 3123.78 | 0.00 | 0.00 | 2443.35 | 680.43 |
| Fernandez, Jillian, K,12599 | 5649.21 | 0.00 | 0.00 | 2071.42 | 3577.79 |
| Sanchez, Brian, F,20931 | 3273.17 | 0.00 | 0.00 | 782.99 | 2490.18 |
| Rubio, Micheal, K,12622 | 5135.41 | 0.00 | 0.00 | 2049.10 | 3086.31 |
| Ortega, Robin,17798 | 3058.31 | 0.00 | 0.00 | 2443.35 | 614.96 |
| Navarro, Walter, S,17841 | 2803.52 | 0.00 | 0.00 | 2181.56 | 621.96 |
| Luo, Chad, R,21040 | 2566.95 | 0.00 | 0.00 | 2566.95 | 0.00 |
Generated 2025-11-02 07:46:14.467 UTC