[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 124 > TITLE Top 1000 Australian Internet customers for 2020
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Romero, Wendy, H,11372 | 4965.81 | 3374.99 | 0.00 | 0.00 | 1590.82 |
| Ramos, Roberto, M,13159 | 208.18 | 0.00 | 0.00 | 0.00 | 208.18 |
| Jai, Rafael, L,17323 | 84.96 | 0.00 | 0.00 | 8.99 | 75.97 |
| Raje, Donna, A,20607 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Martin, Reginald,14054 | 210.77 | 0.00 | 0.00 | 0.00 | 210.77 |
| Torres, Naomi, J,14061 | 82.26 | 0.00 | 0.00 | 82.26 | 0.00 |
| Smith, Kristi, M,21962 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 77.96 | 37.97 |
| Dominguez, Ebony, R,17350 | 127.47 | 0.00 | 0.00 | 34.99 | 92.48 |
| Goel, Dale, M,20416 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Becker, Gregory, M,13104 | 6894.44 | 0.00 | 2071.42 | 2394.97 | 2428.05 |
| Ruiz, Marie, J,27498 | 1350.75 | 0.00 | 0.00 | 1350.75 | 0.00 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 92.97 | 0.00 |
| Becker, Latoya, W,17330 | 30.97 | 0.00 | 0.00 | 21.98 | 8.99 |
| Patel, Gerald,23095 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Bailey, Melissa, C,19572 | 82.25 | 0.00 | 0.00 | 82.25 | 0.00 |
| Lu, Ronnie,19950 | 6098.54 | 0.00 | 3578.27 | 2520.27 | 0.00 |
| Lu, Candice, I,21204 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Rana, Darren, M,17257 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Raman, Summer, C,25949 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 2369.96 | 2419.06 |
| Martin, Natasha, N,27490 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Li, Cedric,27364 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Raji, Andres, E,13955 | 6888.44 | 0.00 | 2071.42 | 0.00 | 4817.02 |
| Lin, Laura, L,11462 | 8116.33 | 0.00 | 3374.99 | 2322.28 | 2419.06 |
| Sun, Dennis, K,24481 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Ms., Sanchez, Madalena, J.,13020 | 2589.09 | 0.00 | 2049.10 | 0.00 | 539.99 |
| Wang, Arturo, A,27720 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Ye, Krystal, M,26923 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| Lopez, Ross,18443 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Campbell, Seth,18716 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Long, Nicole, C,13624 | 114.97 | 0.00 | 0.00 | 59.98 | 54.99 |
| Liu, Steve, V,23523 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Jimenez, Jimmy,27365 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Rubio, Kristy,12243 | 3914.98 | 0.00 | 3374.99 | 539.99 | 0.00 |
| Black, Priscilla,15766 | 62.27 | 0.00 | 0.00 | 62.27 | 0.00 |
| Prasad, Clifford,15604 | 66.75 | 0.00 | 0.00 | 27.28 | 39.47 |
| Cooper, Katherine, R,14314 | 122.95 | 0.00 | 0.00 | 58.98 | 63.97 |
| Zhang, James,14684 | 38.55 | 0.00 | 0.00 | 0.00 | 38.55 |
| Luo, Devon, D,22850 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Ruiz, Carolyn, M,27863 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Sai, Levi,16349 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Ross, Julian,11363 | 5035.81 | 3399.99 | 0.00 | 0.00 | 1635.82 |
| Chen, Jon,26920 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Lin, Heather, L,15718 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Alvarez, Arthur,24892 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Shan, Damien, M,11362 | 77.27 | 0.00 | 0.00 | 27.28 | 49.99 |
| Zhou, Louis, C,17912 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Barnes, Taylor,14279 | 5137.71 | 0.00 | 0.00 | 2800.44 | 2337.27 |
| Madan, Summer, D,12347 | 6839.12 | 0.00 | 2049.10 | 2370.96 | 2419.06 |
| Wang, Randy, G,25125 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Xie, Chad, A,26155 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Tang, Shawn,25832 | 1850.86 | 0.00 | 699.10 | 0.00 | 1151.76 |
| Blanco, Lori, A,15735 | 116.25 | 0.00 | 0.00 | 31.27 | 84.98 |
| Romero, Mallory,26434 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| She, Ashlee,28319 | 556.93 | 0.00 | 0.00 | 556.93 | 0.00 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 2071.42 | 2349.98 | 2443.55 |
| King, Jesse, J,14665 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Martinez, Virginia,13136 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Pal, Mindy,19097 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
| Gao, Jake, A,19955 | 173.45 | 0.00 | 0.00 | 30.48 | 142.97 |
| Zhu, Damien, M,15822 | 43.21 | 0.00 | 0.00 | 14.23 | 28.98 |
| Nath, Tommy, B,28937 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Rana, Joe, D,11916 | 8178.51 | 0.00 | 3374.99 | 2405.47 | 2398.05 |
| Shen, Corey,26739 | 61.97 | 0.00 | 0.00 | 61.97 | 0.00 |
| Nara, Clayton,11768 | 8139.04 | 0.00 | 3399.99 | 2319.99 | 2419.06 |
| Rubio, Marie, V,20618 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Martinez, Douglas, C,22841 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Morris, Eduardo,19619 | 112.75 | 0.00 | 0.00 | 88.97 | 23.78 |
| Munoz, Kendra, S,23529 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Ye, Vincent,13013 | 256.24 | 0.00 | 0.00 | 0.00 | 256.24 |
| Sanz, Tabitha,17496 | 110.96 | 0.00 | 0.00 | 0.00 | 110.96 |
| Sun, Mandy, L,16694 | 78.20 | 0.00 | 0.00 | 39.22 | 38.98 |
| Zeng, Dawn, D,29455 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Jai, Carl,27597 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Garcia, Preston, M,24602 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Wu, Glenn, R,29343 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Sanz, Rodney,16926 | 44.95 | 0.00 | 0.00 | 22.97 | 21.98 |
| He, Karen, C,27861 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Johnsen, Mario, W,26587 | 1920.42 | 0.00 | 782.99 | 0.00 | 1137.43 |
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Arthur, Joel,27701 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 2049.10 | 2343.96 | 2419.06 |
| Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 79.69 | 0.00 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2888.58 | 742.35 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 23.78 | 36.27 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 928.49 | 0.00 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2791.45 | 2349.98 |
| Chander, Damien,11080 | 8204.02 | 3374.99 | 0.00 | 4829.03 | 0.00 |
| Suarez, Orlando,11121 | 58.16 | 0.00 | 0.00 | 7.95 | 50.21 |
| Shan, Brad, H,19605 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 3286.27 | 2457.95 |
| Malhotra, Ruben, M,17074 | 90.25 | 0.00 | 0.00 | 90.25 | 0.00 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 34.99 | 28.98 |
| Gomez, Alfredo, C,18200 | 4150.53 | 3578.27 | 0.00 | 0.00 | 572.26 |
| Pal, Mohamed, D,12698 | 6786.75 | 0.00 | 2071.42 | 2294.99 | 2420.34 |
| Rubio, Jessie, J,27868 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Vance, Ruth, D,17302 | 147.44 | 0.00 | 0.00 | 58.98 | 88.46 |
| Li, Lisa, J,24600 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alvarez, Adrienne, L,17067 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 2049.10 | 0.00 | 4744.05 |
| Munoz, Meredith,13957 | 5645.24 | 0.00 | 0.00 | 2071.42 | 3573.82 |
| Andersen, Warren,11919 | 8171.52 | 0.00 | 3374.99 | 2334.98 | 2461.55 |
| Hernandez, Hailey, A,18727 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Alonso, Jimmy, T,18280 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Subram, Ivan, A,26147 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Ruiz, Shannon,20822 | 4134.53 | 0.00 | 3578.27 | 556.26 | 0.00 |
| Perez, Johnathan, D,20426 | 4139.75 | 0.00 | 3578.27 | 561.48 | 0.00 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 549.98 | 0.00 |
| Torres, Dwayne, R,17288 | 4426.24 | 3578.27 | 0.00 | 0.00 | 847.97 |
| Williams, Madison, J,21198 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Deng, Casey, C,19674 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Yang, Warren, F,17908 | 35.72 | 0.00 | 0.00 | 35.72 | 0.00 |
| Lopez, Francisco, L,18714 | 24.27 | 0.00 | 0.00 | 24.27 | 0.00 |
| Ruiz, Frank, M,14260 | 3716.23 | 0.00 | 0.00 | 2964.89 | 751.34 |
| Ramos, Audrey,11976 | 8087.31 | 0.00 | 3374.99 | 2319.26 | 2393.06 |
| Deng, April,11117 | 8184.99 | 3399.99 | 0.00 | 4785.00 | 0.00 |
| Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2813.77 | 2294.99 |
Generated 2026-07-21 19:15:51.782 UTC