[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > 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 |
|---|---|---|---|---|---|
| Long, Emily, L,26140 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Lal, Shawna,17924 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Wang, Curtis, A,13108 | 5718.66 | 0.00 | 2071.42 | 0.00 | 3647.24 |
| Hu, Krystal, D,13012 | 7017.44 | 0.00 | 2071.42 | 2493.98 | 2452.04 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 4.99 | 188.98 |
| Shen, Shaun,12684 | 6893.08 | 0.00 | 2049.10 | 2410.94 | 2433.04 |
| Ward, Brooke,13007 | 5671.24 | 0.00 | 2071.42 | 1249.84 | 2349.98 |
| Chow, Amy, E,12699 | 6798.13 | 0.00 | 2049.10 | 2364.96 | 2384.07 |
| Alexander, Gabriel, C,14073 | 156.84 | 0.00 | 0.00 | 38.88 | 117.96 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 344.04 | 0.00 |
| Gray, Faith,22914 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Luo, Ashlee,23534 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Watson, Maria,17229 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Ramos, Marie, A,14308 | 5140.40 | 0.00 | 0.00 | 2049.10 | 3091.30 |
| Perez, Ross, E,14307 | 196.26 | 0.00 | 0.00 | 163.99 | 32.27 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Xie, Dustin,22204 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Beck, Donna, J,18247 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Moreno, Beth,21980 | 4334.61 | 0.00 | 2443.35 | 0.00 | 1891.26 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Rai, Brendan, A,21569 | 4960.16 | 0.00 | 2443.35 | 0.00 | 2516.81 |
| Zhao, Rosa, A,19672 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Moreno, Deanna,28941 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Arun, Troy, P,15221 | 4447.87 | 0.00 | 0.00 | 2071.42 | 2376.45 |
| Shen, Karl, M,15151 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Hill, Noah,26192 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Cai, Curtis,21259 | 3907.54 | 0.00 | 2181.56 | 0.00 | 1725.98 |
| Alexander, David,15783 | 98.96 | 0.00 | 0.00 | 34.99 | 63.97 |
| Peterson, Allison, A,26421 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Perez, Janelle,16172 | 186.04 | 0.00 | 0.00 | 0.00 | 186.04 |
| Anand, Kelli, A,20451 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Serrano, Javier, R,20256 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| Goel, Brad, M,29085 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Munoz, Alfredo, C,23314 | 2744.52 | 0.00 | 2181.56 | 0.00 | 562.96 |
| Suri, Roy, M,17253 | 53.99 | 0.00 | 0.00 | 53.99 | 0.00 |
| Raji, Misty,16520 | 4727.74 | 3578.27 | 0.00 | 1149.47 | 0.00 |
| Xu, Barbara,29195 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Li, Stacey,14064 | 5694.21 | 0.00 | 0.00 | 3375.25 | 2318.96 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 31.27 | 58.98 |
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 2071.42 | 2329.99 | 2419.06 |
| Raje, Rafael, M,13000 | 6799.45 | 0.00 | 2071.42 | 2294.99 | 2433.04 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 49.99 | 49.48 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 2412.96 | 778.62 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 2071.42 | 2369.96 | 2419.06 |
| Sanchez, Carla,18274 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Alvarez, Kristy,15588 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Sara, Tina,24307 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Romero, Sabrina, L,28534 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Romero, Rodney,14521 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Perez, Patricia,25022 | 1564.92 | 0.00 | 0.00 | 1000.44 | 564.48 |
| Gonzalez, Kaylee, L,21895 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Dominguez, Josue, R,15600 | 4590.40 | 0.00 | 0.00 | 2071.42 | 2518.98 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 34.99 | 88.46 |
| Hernandez, Audrey,18290 | 84.96 | 0.00 | 0.00 | 8.99 | 75.97 |
| Black, Peter, E,21213 | 64.26 | 0.00 | 0.00 | 0.00 | 64.26 |
| Price, Vanessa, A,23569 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Weber, Cory,16739 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Serrano, Darren,29196 | 2438.06 | 0.00 | 0.00 | 2438.06 | 0.00 |
| Vazquez, Ruben, B,14301 | 5142.75 | 0.00 | 0.00 | 2071.42 | 3071.33 |
| Rodriguez, Donald, L,28351 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Carlson, Joy,13981 | 124.21 | 0.00 | 0.00 | 88.98 | 35.23 |
| Ma, Warren, A,19762 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Liang, Tiffany,11068 | 113.36 | 0.00 | 0.00 | 38.47 | 74.89 |
| Gomez, Armando, S,21175 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Alonso, Casey, E,23422 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Malhotra, Darren, L,20245 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 4733.05 | 0.00 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 1205.47 | 0.00 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 1179.97 | 0.00 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 2408.97 | 756.33 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 2399.47 | 776.33 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Sun, Jaclyn,18211 | 65.96 | 0.00 | 0.00 | 56.97 | 8.99 |
| Wang, Alan,13622 | 6841.43 | 0.00 | 2071.42 | 0.00 | 4770.01 |
| Lin, Margaret, C,18306 | 87.77 | 0.00 | 0.00 | 2.29 | 85.48 |
| Alonso, Sheila,25054 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Smith, Allen,14072 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Deng, Barbara,20445 | 6078.71 | 0.00 | 3578.27 | 0.00 | 2500.44 |
| Goel, Drew,17352 | 6021.62 | 3578.27 | 0.00 | 0.00 | 2443.35 |
| Chander, Roger,25214 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Martin, Joe,14668 | 5216.69 | 0.00 | 0.00 | 2071.42 | 3145.27 |
| Yang, Rosa,18713 | 237.26 | 0.00 | 0.00 | 0.00 | 237.26 |
| Xu, Tonya,17324 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Nelson, Fernando, G,25564 | 1253.07 | 699.10 | 0.00 | 0.00 | 553.97 |
| Hernandez, Brandi, C,21893 | 4663.79 | 0.00 | 2181.56 | 0.00 | 2482.23 |
| Cooper, Allison, J,29294 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 2482.23 | 0.00 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 806.76 | 0.00 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Lu, Jaclyn, D,11047 | 6582.33 | 3399.99 | 0.00 | 0.00 | 3182.34 |
| Raje, Ashlee, E,16658 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Martin, Marc, J,11039 | 6636.58 | 3399.99 | 0.00 | 0.00 | 3236.59 |
| She, Alvin, E,16657 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Nelson, Sophia,16664 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Ye, Dennis, M,16638 | 5974.23 | 3578.27 | 0.00 | 0.00 | 2395.96 |
| Scott, Savannah, E,16929 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Lopez, Heidi,11052 | 8131.32 | 3374.99 | 0.00 | 4756.33 | 0.00 |
| Stone, Denise,11032 | 6525.56 | 3374.99 | 0.00 | 0.00 | 3150.57 |
| Gutierrez, Natasha,17048 | 4382.75 | 3578.27 | 0.00 | 804.48 | 0.00 |
| Raman, Patricia, T,16702 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Sai, Preston, D,17046 | 4467.74 | 3578.27 | 0.00 | 889.47 | 0.00 |
| Andersen, Carl, J,11057 | 8088.04 | 3374.99 | 0.00 | 4713.05 | 0.00 |
| Nara, Tony, L,16713 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Hernandez, Jacquelyn, J,21568 | 4659.80 | 0.00 | 2181.56 | 0.00 | 2478.24 |
| Shen, Willie, S,18450 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Nara, Leonard, G,11045 | 114.96 | 0.00 | 0.00 | 64.97 | 49.99 |
| Ye, Edwin,18334 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
Generated 2026-07-21 03:59:49.353 UTC