[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 |
|---|---|---|---|---|---|
| Goel, Yolanda, M,26435 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Price, Megan,24907 | 2183.91 | 0.00 | 1000.44 | 1183.47 | 0.00 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Guo, Jon,22927 | 3913.82 | 0.00 | 2181.56 | 0.00 | 1732.26 |
| Rana, Darren, M,17257 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Jai, Maurice,22932 | 4169.33 | 0.00 | 2443.35 | 1725.98 | 0.00 |
| Raman, Summer, C,25949 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Moreno, Mallory, P,22912 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 2369.96 | 2419.06 |
| Liang, Barbara, T,22953 | 3899.49 | 0.00 | 2181.56 | 1717.93 | 0.00 |
| Hernandez, Danny,27146 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 2443.35 | 0.00 | 1725.98 |
| Johnsen, Jerry,26670 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Nelson, Mary, L,13107 | 5650.90 | 0.00 | 2049.10 | 0.00 | 3601.80 |
| Rubio, Bruce, E,23343 | 3936.54 | 0.00 | 0.00 | 3936.54 | 0.00 |
| Mehta, Levi, M,13110 | 5583.94 | 0.00 | 2049.10 | 0.00 | 3534.84 |
| Chander, Drew, J,25111 | 2145.92 | 0.00 | 0.00 | 2145.92 | 0.00 |
| Andersen, Karl, M,23105 | 3361.53 | 0.00 | 2181.56 | 1179.97 | 0.00 |
| Pais, Wilson, C,13038 | 5581.26 | 0.00 | 2071.42 | 1214.85 | 2294.99 |
| Goel, Tommy,22909 | 3980.52 | 0.00 | 2181.56 | 0.00 | 1798.96 |
| Muñoz, Ruben, L,11451 | 8249.49 | 0.00 | 3399.99 | 4849.50 | 0.00 |
| Davis, Isabella, A,22929 | 4673.88 | 0.00 | 2181.56 | 0.00 | 2492.32 |
| Flores, Miranda,17243 | 83.98 | 0.00 | 0.00 | 83.98 | 0.00 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 2181.56 | 0.00 | 1779.47 |
| Subram, Roy,21896 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 1000.44 | 1179.47 | 0.00 |
| Jackson, Joshua,17235 | 83.98 | 0.00 | 0.00 | 53.99 | 29.99 |
| Lal, Kelsey, T,24913 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Anand, Leonard,14316 | 3797.37 | 0.00 | 0.00 | 2907.57 | 889.80 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Clark, Sydney,16610 | 67.58 | 0.00 | 0.00 | 67.58 | 0.00 |
| Rai, Johnny, A,13135 | 6773.14 | 0.00 | 2049.10 | 2304.98 | 2419.06 |
| Ramos, Mary, B,15019 | 72.96 | 0.00 | 0.00 | 8.99 | 63.97 |
| Kovár, Whitney,13105 | 5585.45 | 0.00 | 2049.10 | 0.00 | 3536.35 |
| Mehta, Edgar,11761 | 8149.49 | 0.00 | 3399.99 | 2356.44 | 2393.06 |
| Shen, Kelsey, R,22921 | 4647.88 | 0.00 | 2181.56 | 0.00 | 2466.32 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 3399.99 | 0.00 | 2318.96 | 2418.05 |
| Diaz, Jill, F,22936 | 3946.52 | 0.00 | 2181.56 | 0.00 | 1764.96 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 778.62 | 0.00 |
| Cox, Catherine, K,13122 | 6871.43 | 0.00 | 2071.42 | 2380.95 | 2419.06 |
| Sai, Cassandra, R,28110 | 845.31 | 0.00 | 0.00 | 845.31 | 0.00 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 782.99 | 0.00 | 553.97 |
| Gutierrez, Jay, C,13155 | 226.95 | 0.00 | 0.00 | 217.96 | 8.99 |
| Kennedy, Devon, J,13133 | 6813.12 | 0.00 | 2049.10 | 0.00 | 4764.02 |
| Lu, Ramon, B,16738 | 44.95 | 0.00 | 0.00 | 44.95 | 0.00 |
| Shen, Tamara, G,22935 | 3951.52 | 0.00 | 2181.56 | 0.00 | 1769.96 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 2181.56 | 588.96 | 0.00 |
| Sanchez, Bryant, C,13113 | 6832.41 | 0.00 | 2071.42 | 0.00 | 4760.99 |
| Ma, Amy, E,17309 | 6030.61 | 3578.27 | 0.00 | 2452.34 | 0.00 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Butler, Destiny,27865 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Natsuhara, Tony,23097 | 2770.52 | 0.00 | 2181.56 | 0.00 | 588.96 |
| Griffin, Brianna, K,16487 | 73.24 | 0.00 | 0.00 | 24.27 | 48.97 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 2071.42 | 0.00 | 3626.10 |
| Romero, Wendy, H,11372 | 4965.81 | 3374.99 | 0.00 | 0.00 | 1590.82 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 2049.10 | 0.00 | 3599.82 |
| Ramos, Roberto, M,13159 | 208.18 | 0.00 | 0.00 | 0.00 | 208.18 |
| Kumar, Tonya, A,22934 | 4173.32 | 0.00 | 2443.35 | 0.00 | 1729.97 |
| Jai, Rafael, L,17323 | 84.96 | 0.00 | 0.00 | 8.99 | 75.97 |
| Yuan, Keith, N,22926 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Raje, Donna, A,20607 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 2443.35 | 1798.96 | 0.00 |
| Martin, Reginald,14054 | 210.77 | 0.00 | 0.00 | 0.00 | 210.77 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 2049.10 | 0.00 | 4688.05 |
| Shan, Damien, M,11362 | 77.27 | 0.00 | 0.00 | 27.28 | 49.99 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 782.99 | 0.00 | 578.46 |
| Zhou, Louis, C,17912 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 2049.10 | 0.00 | 4730.32 |
| Barnes, Taylor,14279 | 5137.71 | 0.00 | 0.00 | 2800.44 | 2337.27 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 2049.10 | 2443.35 | 0.00 |
| Madan, Summer, D,12347 | 6839.12 | 0.00 | 2049.10 | 2370.96 | 2419.06 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 2181.56 | 1308.47 | 0.00 |
| Wang, Randy, G,25125 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Raman, Brett, L,22930 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Xie, Chad, A,26155 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 2443.35 | 0.00 | 1735.98 |
| Tang, Shawn,25832 | 1850.86 | 0.00 | 699.10 | 0.00 | 1151.76 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 2049.10 | 0.00 | 4768.04 |
| Carlson, Orlando, J,11893 | 8123.03 | 0.00 | 3374.99 | 2319.99 | 2428.05 |
| Garcia, Martin, l,23332 | 4144.34 | 0.00 | 2443.35 | 1700.99 | 0.00 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 9.99 | 22.97 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 2071.42 | 0.00 | 4753.31 |
| Rodriguez, Geoffrey,20817 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Perez, Ivan, S,23408 | 4218.82 | 0.00 | 2443.35 | 1775.47 | 0.00 |
| Jimenez, Krista,18257 | 115.95 | 0.00 | 0.00 | 106.96 | 8.99 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 2181.56 | 1209.47 | 0.00 |
| Garcia, Frederick, J,16489 | 112.73 | 0.00 | 0.00 | 112.73 | 0.00 |
| Zhang, Glenn, A,13967 | 5721.91 | 0.00 | 2049.10 | 0.00 | 3672.81 |
| Raji, Brendan,13103 | 6842.60 | 0.00 | 2049.10 | 2395.45 | 2398.05 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 782.99 | 574.98 | 0.00 |
| Chandra, Rebekah,28486 | 776.33 | 0.00 | 0.00 | 776.33 | 0.00 |
| Allen, Kaylee,26653 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Mitchell, Wyatt, A,14048 | 5123.74 | 0.00 | 0.00 | 2813.77 | 2309.97 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| He, Aimee, A,11093 | 8180.00 | 3399.99 | 0.00 | 4780.01 | 0.00 |
| Rodriguez, Jarrod,13636 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 83.97 | 0.00 |
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Weber, Deanna, L,14855 | 3759.08 | 0.00 | 0.00 | 3759.08 | 0.00 |
| Sai, Emmanuel,23417 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Chande, Katrina, L,19968 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Suarez, Rebekah,13649 | 6812.13 | 0.00 | 0.00 | 2049.10 | 4763.03 |
| Alan, Bob, A,27366 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Andersen, Gilbert, T,27353 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Li, Wesley,23322 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Ye, Amy,11073 | 191.90 | 0.00 | 0.00 | 168.93 | 22.97 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Ye, Alejandro, W,15029 | 3826.40 | 0.00 | 0.00 | 3826.40 | 0.00 |
| Yuan, Terry, R,13646 | 6843.60 | 0.00 | 0.00 | 2049.10 | 4794.50 |
| Yuan, Marshall, P,19978 | 6060.50 | 0.00 | 3578.27 | 2482.23 | 0.00 |
| Nara, Gregory,26651 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Blanco, Orlando,22575 | 3018.33 | 0.00 | 2443.35 | 574.98 | 0.00 |
| Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
| Lee, Dalton, J,16931 | 4767.73 | 3578.27 | 0.00 | 1189.46 | 0.00 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Martin, Natasha, N,27490 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Romero, Walter, A,25020 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Ye, Vincent,13013 | 256.24 | 0.00 | 0.00 | 0.00 | 256.24 |
| Xu, Karl,23321 | 3060.82 | 0.00 | 0.00 | 2443.35 | 617.47 |
| Raji, Andres, E,13955 | 6888.44 | 0.00 | 2071.42 | 0.00 | 4817.02 |
| Fernandez, Cassandra, C,14134 | 3835.07 | 0.00 | 0.00 | 3835.07 | 0.00 |
| Sanz, Tabitha,17496 | 110.96 | 0.00 | 0.00 | 0.00 | 110.96 |
Generated 2026-07-21 22:37:52.514 UTC