[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 |
|---|---|---|---|---|---|
| Goel, Yolanda, M,26435 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Ye, Tamara, A,20243 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Price, Megan,24907 | 2183.91 | 0.00 | 1000.44 | 1183.47 | 0.00 |
| Sun, Louis, E,16182 | 83.97 | 0.00 | 0.00 | 58.98 | 24.99 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Hernandez, Wendy, A,15124 | 122.44 | 0.00 | 0.00 | 122.44 | 0.00 |
| Guo, Jon,22927 | 3913.82 | 0.00 | 2181.56 | 0.00 | 1732.26 |
| Zhou, Laura, D,12683 | 6801.45 | 0.00 | 2071.42 | 2316.97 | 2413.06 |
| Jai, Maurice,22932 | 4169.33 | 0.00 | 2443.35 | 1725.98 | 0.00 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 2049.10 | 1249.84 | 2395.96 |
| Moreno, Mallory, P,22912 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Jiménez, Brandi,24378 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Sanchez, Bryant, C,13113 | 6832.41 | 0.00 | 2071.42 | 0.00 | 4760.99 |
| Rodriguez, Bobby,15752 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 2049.10 | 0.00 | 4730.32 |
| Guo, Jaclyn,13119 | 6829.45 | 0.00 | 2071.42 | 0.00 | 4758.03 |
| Wang, Autumn,13049 | 5647.22 | 0.00 | 2071.42 | 1223.84 | 2351.96 |
| Gutierrez, Pedro, S,15224 | 71.92 | 0.00 | 0.00 | 36.93 | 34.99 |
| Zimmerman, Krystal,17228 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Hernandez, Walter,13141 | 240.24 | 0.00 | 0.00 | 0.00 | 240.24 |
| Raji, Maurice, C,20619 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Foster, Aidan,26445 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Malhotra, Terrance, E,20223 | 187.38 | 0.00 | 0.00 | 0.00 | 187.38 |
| Zhu, Alan,17320 | 4391.74 | 3578.27 | 0.00 | 0.00 | 813.47 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Cook, Victoria, J,20620 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Srini, Joe,22180 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Lin, Darryl, J,15031 | 41.27 | 0.00 | 0.00 | 32.28 | 8.99 |
| Goel, Tommy,22909 | 3980.52 | 0.00 | 2181.56 | 0.00 | 1798.96 |
| Gao, Krystal,25821 | 1879.07 | 0.00 | 699.10 | 0.00 | 1179.97 |
| Gomez, Kathleen, J,16158 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Carlson, Philip, P,11915 | 8143.00 | 0.00 | 3374.99 | 2369.96 | 2398.05 |
| Nath, Jaime,11033 | 6495.29 | 3374.99 | 0.00 | 0.00 | 3120.30 |
| Vazquez, Rodney, M,13047 | 241.93 | 0.00 | 0.00 | 0.00 | 241.93 |
| Liang, Barbara, T,22953 | 3899.49 | 0.00 | 2181.56 | 1717.93 | 0.00 |
| Lopez, George,15040 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 2443.35 | 0.00 | 1725.98 |
| Ye, Leah,11077 | 8169.03 | 3374.99 | 0.00 | 4794.04 | 0.00 |
| Nelson, Mary, L,13107 | 5650.90 | 0.00 | 2049.10 | 0.00 | 3601.80 |
| Butler, Austin, W,18293 | 74.24 | 0.00 | 0.00 | 74.24 | 0.00 |
| Mehta, Levi, M,13110 | 5583.94 | 0.00 | 2049.10 | 0.00 | 3534.84 |
| Sanz, Mathew, L,14557 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Andersen, Karl, M,23105 | 3361.53 | 0.00 | 2181.56 | 1179.97 | 0.00 |
| Malhotra, Ross, R,29307 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Davis, Isabella, A,22929 | 4673.88 | 0.00 | 2181.56 | 0.00 | 2492.32 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 86.93 | 59.98 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 2181.56 | 0.00 | 1779.47 |
| Wu, Mandy,18309 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 1000.44 | 1179.47 | 0.00 |
| Raje, Jodi, E,19630 | 74.45 | 0.00 | 0.00 | 74.45 | 0.00 |
| Lal, Kelsey, T,24913 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Ramos, Danny,23121 | 4144.34 | 0.00 | 2443.35 | 1700.99 | 0.00 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Suarez, Jacquelyn, C,11010 | 8088.04 | 3399.99 | 0.00 | 4688.05 | 0.00 |
| Rai, Johnny, A,13135 | 6773.14 | 0.00 | 2049.10 | 2304.98 | 2419.06 |
| Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Kovár, Whitney,13105 | 5585.45 | 0.00 | 2049.10 | 0.00 | 3536.35 |
| Prasad, Edgar, E,17306 | 117.96 | 0.00 | 0.00 | 117.96 | 0.00 |
| Shen, Kelsey, R,22921 | 4647.88 | 0.00 | 2181.56 | 0.00 | 2466.32 |
| Alvarez, Mathew, L,17494 | 111.96 | 0.00 | 0.00 | 111.96 | 0.00 |
| Diaz, Jill, F,22936 | 3946.52 | 0.00 | 2181.56 | 0.00 | 1764.96 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 2319.99 | 2400.34 |
| Cox, Catherine, K,13122 | 6871.43 | 0.00 | 2071.42 | 2380.95 | 2419.06 |
| Sai, Bruce,22194 | 4633.90 | 0.00 | 2181.56 | 0.00 | 2452.34 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 782.99 | 0.00 | 553.97 |
| Sara, Tabitha, W,25715 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Kennedy, Devon, J,13133 | 6813.12 | 0.00 | 2049.10 | 0.00 | 4764.02 |
| Cai, Vincent, L,11757 | 58.05 | 0.00 | 0.00 | 24.49 | 33.56 |
| Shen, Tamara, G,22935 | 3951.52 | 0.00 | 2181.56 | 0.00 | 1769.96 |
| Deng, Latoya, H,21969 | 4759.47 | 0.00 | 2181.56 | 0.00 | 2577.91 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Shen, Barbara,22030 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Natsuhara, Tony,23097 | 2770.52 | 0.00 | 2181.56 | 0.00 | 588.96 |
| Gutierrez, Darren, A,25714 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 2071.42 | 0.00 | 3626.10 |
| Smith, Christian, L,14313 | 222.44 | 0.00 | 0.00 | 0.00 | 222.44 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 2049.10 | 0.00 | 3599.82 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Kumar, Tonya, A,22934 | 4173.32 | 0.00 | 2443.35 | 0.00 | 1729.97 |
| Yang, Cedric,15038 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Perez, Martin,19577 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Vazquez, Kristine, M,17736 | 4742.74 | 3578.27 | 0.00 | 0.00 | 1164.47 |
| Ramos, Gloria, A,21365 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Shan, Deborah,20624 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 28.98 | 0.00 |
| Williams, Nicholas, A,25809 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Becker, Julie,13614 | 114.21 | 0.00 | 0.00 | 86.93 | 27.28 |
| Torres, Theresa,21202 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 8.99 | 88.98 |
| Johnson, Emma, M,15136 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Suri, Jarrod, E,12004 | 8114.04 | 0.00 | 3374.99 | 2319.99 | 2419.06 |
| Guo, Jake, P,19969 | 98.45 | 0.00 | 0.00 | 98.45 | 0.00 |
| Griffin, Olivia,21208 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Gao, Erica, R,19087 | 47.20 | 0.00 | 0.00 | 47.20 | 0.00 |
| Pal, Terrence, M,13037 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Lin, Suzanne,29287 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Li, Justin,14124 | 57.59 | 0.00 | 0.00 | 32.60 | 24.99 |
| Hu, Aimee, R,27981 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 3814.06 | 0.00 |
| Deng, Kurt, D,13635 | 215.74 | 0.00 | 0.00 | 32.27 | 183.47 |
| Gomez, Erik, T,29180 | 2452.04 | 0.00 | 0.00 | 2452.04 | 0.00 |
| Andersen, Kelvin, C,21366 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Ye, Claudia, J,19102 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Bhat, Edwin,13079 | 6752.13 | 0.00 | 2049.10 | 2309.97 | 2393.06 |
| Goel, Mario, J,12360 | 6750.48 | 0.00 | 2071.42 | 2294.99 | 2384.07 |
| Ruiz, Krista, C,13081 | 6772.15 | 0.00 | 2049.10 | 2329.99 | 2393.06 |
| Chande, Bonnie, L,23992 | 3167.82 | 0.00 | 0.00 | 2443.35 | 724.47 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 94.22 | 0.00 |
| Zhao, Shannon,19807 | 35.47 | 0.00 | 0.00 | 0.00 | 35.47 |
| Gutierrez, Lawrence, M,19564 | 5293.24 | 0.00 | 3578.27 | 1714.97 | 0.00 |
| Griffin, Noah, E,29118 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| She, Jerry, C,14277 | 5196.74 | 0.00 | 0.00 | 2876.75 | 2319.99 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 1000.44 | 1145.48 | 0.00 |
| Torres, Gina,17904 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Hayes, Eric, A,22964 | 123.98 | 0.00 | 0.00 | 123.98 | 0.00 |
| Ortega, Joanna,17909 | 4761.74 | 3578.27 | 0.00 | 0.00 | 1183.47 |
| Rodriguez, Dylan, E,16611 | 75.53 | 0.00 | 0.00 | 42.93 | 32.60 |
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| Munoz, Marvin,14680 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Yuan, Keith, N,22926 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Raman, Jay, M,13618 | 6763.15 | 0.00 | 0.00 | 4344.09 | 2419.06 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 2443.35 | 1798.96 | 0.00 |
| Diaz, Vanessa, J,29100 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 2049.10 | 0.00 | 4688.05 |
Generated 2026-07-21 15:12:32.771 UTC