[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > 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 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 344.04 | 0.00 |
| Scott, Alex, T,14348 | 2989.38 | 0.00 | 0.00 | 2071.42 | 917.96 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 4733.05 | 0.00 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 782.99 | 574.98 | 0.00 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Nara, Priscilla,18907 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Raji, Misty,16520 | 4727.74 | 3578.27 | 0.00 | 1149.47 | 0.00 |
| Sharma, Tony,18241 | 6058.21 | 3578.27 | 0.00 | 2479.94 | 0.00 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Lal, Katie, E,18210 | 6044.59 | 3578.27 | 0.00 | 2466.32 | 0.00 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 2181.56 | 1308.47 | 0.00 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 1205.47 | 0.00 |
| Pal, Gilbert,27744 | 643.95 | 0.00 | 0.00 | 643.95 | 0.00 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Mehta, Marco,11007 | 8211.00 | 3399.99 | 0.00 | 4811.01 | 0.00 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Chen, Steve, R,18902 | 4186.23 | 0.00 | 3578.27 | 607.96 | 0.00 |
| Gray, Faith,22914 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Mehta, Tina, C,11444 | 8136.02 | 3374.99 | 0.00 | 4761.03 | 0.00 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 1179.97 | 0.00 |
| Pal, Christine, I,18242 | 6121.71 | 3578.27 | 0.00 | 2543.44 | 0.00 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 2412.96 | 778.62 |
| Jordan, Ross, F,11124 | 8129.02 | 3399.99 | 0.00 | 4729.03 | 0.00 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Lal, Mario, T,23345 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Alvarez, Roy, A,16709 | 143.94 | 0.00 | 0.00 | 0.00 | 143.94 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Chander, Dustin,11895 | 8149.04 | 0.00 | 3374.99 | 2354.99 | 2419.06 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 2408.97 | 756.33 |
| Suarez, Tabitha,25110 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Goel, Jodi,20447 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 2399.47 | 776.33 |
| Mehta, Brett,11450 | 8173.26 | 3374.99 | 0.00 | 4798.27 | 0.00 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Sai, Abby, L,11101 | 8262.52 | 3399.99 | 0.00 | 4862.53 | 0.00 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Kumar, Chad,11095 | 8158.01 | 3374.99 | 0.00 | 4783.02 | 0.00 |
| Suri, Roy, M,17253 | 53.99 | 0.00 | 0.00 | 53.99 | 0.00 |
| Sanz, Arthur,27688 | 166.28 | 0.00 | 0.00 | 166.28 | 0.00 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Zhang, Barbara,16338 | 169.43 | 0.00 | 0.00 | 169.43 | 0.00 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 2482.23 | 0.00 |
| Suarez, Pedro, A,24611 | 2219.42 | 0.00 | 1000.44 | 1218.98 | 0.00 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 806.76 | 0.00 |
| Sharma, Lindsay, E,24478 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Torres, Marc,11765 | 8143.03 | 0.00 | 3374.99 | 2294.99 | 2473.05 |
| Lu, Jaclyn, D,11047 | 6582.33 | 3399.99 | 0.00 | 0.00 | 3182.34 |
| Fernandez, Tammy, A,25825 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raje, Ashlee, E,16658 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Ramos, Alfredo,20456 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Martin, Marc, J,11039 | 6636.58 | 3399.99 | 0.00 | 0.00 | 3236.59 |
| Kennedy, Devon, J,13133 | 6813.12 | 0.00 | 2049.10 | 0.00 | 4764.02 |
| She, Alvin, E,16657 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 2071.42 | 0.00 | 4753.31 |
| Nelson, Sophia,16664 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Chande, Raul, L,21176 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Ye, Dennis, M,16638 | 5974.23 | 3578.27 | 0.00 | 0.00 | 2395.96 |
| Gutierrez, Frank, G,22846 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Scott, Savannah, E,16929 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Fernandez, Ross, R,11763 | 76.65 | 0.00 | 0.00 | 24.49 | 52.16 |
| Lopez, Heidi,11052 | 8131.32 | 3374.99 | 0.00 | 4756.33 | 0.00 |
| Taylor, Jennifer,18470 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Xu, Barbara,29195 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Blanco, Rodney, A,20158 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Stone, Denise,11032 | 6525.56 | 3374.99 | 0.00 | 0.00 | 3150.57 |
| Zimmerman, Krystal,17228 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Gutierrez, Natasha,17048 | 4382.75 | 3578.27 | 0.00 | 804.48 | 0.00 |
| Yuan, Roger,19622 | 61.75 | 0.00 | 0.00 | 25.48 | 36.27 |
| Raman, Patricia, T,16702 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Li, Wesley,23322 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Sai, Preston, D,17046 | 4467.74 | 3578.27 | 0.00 | 889.47 | 0.00 |
| Alonso, Teresa,13138 | 83.97 | 0.00 | 0.00 | 58.98 | 24.99 |
| Andersen, Carl, J,11057 | 8088.04 | 3374.99 | 0.00 | 4713.05 | 0.00 |
| Reed, Steven,24373 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Nara, Tony, L,16713 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Moreno, Janet, L,15592 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Li, Stacey,14064 | 5694.21 | 0.00 | 0.00 | 3375.25 | 2318.96 |
| Xu, Roger,27968 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 31.27 | 58.98 |
| Parker, Mason, W,25923 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Liu, Candice,28720 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Wilson, Zachary,25558 | 1307.06 | 699.10 | 0.00 | 0.00 | 607.96 |
| Zhang, Jenny, H,24609 | 2120.93 | 0.00 | 1000.44 | 1120.49 | 0.00 |
| Kumar, Deborah, K,17308 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Srini, Veronica,11996 | 7058.70 | 0.00 | 3374.99 | 1291.77 | 2391.94 |
| Watson, Maria,17229 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Xie, Alvin, M,16617 | 160.55 | 0.00 | 0.00 | 69.97 | 90.58 |
| Wu, Micah,17246 | 4380.04 | 3578.27 | 0.00 | 0.00 | 801.77 |
| Nath, Michele, L,11056 | 8207.50 | 3374.99 | 0.00 | 4832.51 | 0.00 |
| Ferrier, Jaclyn, D,17299 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Bradley, Diane, A,15140 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Zheng, Christy,17069 | 4426.74 | 3578.27 | 0.00 | 848.47 | 0.00 |
| Munoz, Shannon, S,29122 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Gao, Todd, M,11061 | 8129.02 | 3374.99 | 0.00 | 4754.03 | 0.00 |
| Johnsen, Ross,19618 | 119.45 | 0.00 | 0.00 | 30.48 | 88.97 |
| Beck, Alicia, L,17248 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Ashe, Brad,25228 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Deng, Clayton, G,17285 | 6093.20 | 3578.27 | 0.00 | 2514.93 | 0.00 |
| Sanchez, Bryant, C,13113 | 6832.41 | 0.00 | 2071.42 | 0.00 | 4760.99 |
| Green, Fernando,17258 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Natsuhara, Tony,23097 | 2770.52 | 0.00 | 2181.56 | 0.00 | 588.96 |
| Chander, Omar, W,17241 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Zheng, Arturo, C,11467 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Lopez, Luis, P,17334 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Yang, Stacey,14215 | 5665.89 | 0.00 | 0.00 | 3298.94 | 2366.95 |
| Lal, Shaun, H,17056 | 4417.75 | 3578.27 | 0.00 | 839.48 | 0.00 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 186.94 | 0.00 |
| Martin, Joan, R,25556 | 1253.07 | 699.10 | 0.00 | 0.00 | 553.97 |
| Luo, Barbara,27978 | 29.48 | 0.00 | 0.00 | 29.48 | 0.00 |
| Sanchez, Troy, H,25559 | 1253.07 | 699.10 | 0.00 | 0.00 | 553.97 |
| Martin, Ethan, M,13998 | 245.25 | 0.00 | 0.00 | 97.97 | 147.28 |
| Flores, Noah,17256 | 4362.74 | 3578.27 | 0.00 | 0.00 | 784.47 |
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 64.97 | 156.94 |
| Goel, Nichole, A,17277 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| Xie, Dawn,21391 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Mr., Shakespear, Paul, J.,17326 | 4467.76 | 3578.27 | 0.00 | 0.00 | 889.49 |
| Ruiz, Leslie, J,26032 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
Generated 2026-07-21 13:33:39.274 UTC