[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 |
|---|---|---|---|---|---|
| Suarez, Lawrence, C,26131 | 1952.45 | 0.00 | 782.99 | 0.00 | 1169.46 |
| Lal, Nina, L,14263 | 5647.93 | 0.00 | 0.00 | 2049.10 | 3598.83 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 23.78 | 36.27 |
| Zeng, Dennis, S,13050 | 5651.25 | 0.00 | 2071.42 | 1249.84 | 2329.99 |
| Kumar, Bethany,29299 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Sanchez, Ross,28310 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanz, Jésus,29313 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Dominguez, Theodore, F,21987 | 4638.89 | 0.00 | 2181.56 | 0.00 | 2457.33 |
| Romero, Gary,22181 | 4673.88 | 0.00 | 2181.56 | 0.00 | 2492.32 |
| Luo, Julie, M,29121 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Parker, Gabriella,21394 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Raman, Veronica, R,12359 | 95.74 | 0.00 | 0.00 | 0.00 | 95.74 |
| Chander, Alisha,12572 | 2611.41 | 0.00 | 2071.42 | 0.00 | 539.99 |
| Madan, Jarrod, C,21555 | 4715.49 | 0.00 | 2181.56 | 0.00 | 2533.93 |
| Prasad, Clifford,15604 | 66.75 | 0.00 | 0.00 | 27.28 | 39.47 |
| Gonzalez, Jan, A,15262 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Raman, Virginia,26159 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Kelly, Emma, A,15646 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Flores, Connor,15755 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Flores, Adam, L,11044 | 6515.30 | 3374.99 | 0.00 | 0.00 | 3140.31 |
| Yuan, Calvin,17905 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 59.98 | 143.48 |
| Gutierrez, Hector,26423 | 2001.97 | 0.00 | 782.99 | 0.00 | 1218.98 |
| Martinez, Bruce, D,18452 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Rai, Calvin,15229 | 2833.57 | 0.00 | 0.00 | 2049.10 | 784.47 |
| Yuan, Bethany, G,11030 | 6471.32 | 3399.99 | 0.00 | 0.00 | 3071.33 |
| Diaz, Dana, C,12361 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Liang, Amy,16164 | 2639.08 | 0.00 | 0.00 | 2049.10 | 589.98 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2888.58 | 742.35 |
| Goel, Karla, L,11146 | 112.93 | 0.00 | 0.00 | 53.95 | 58.98 |
| Zhao, Jamie,16179 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Gutierrez, Dana,20254 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sanchez, Henry,26968 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Lin, Heather, L,15718 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Alvarez, Jessie,14324 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| King, Kevin, W,21402 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Zeng, Alvin, M,11118 | 115.85 | 0.00 | 0.00 | 77.92 | 37.93 |
| Guo, Autumn, A,14213 | 86.26 | 0.00 | 0.00 | 58.98 | 27.28 |
| Patel, Summer, G,26753 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Lal, Alisha, C,21872 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Xie, Lindsey, M,25132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raji, Lacey, E,16341 | 88.25 | 0.00 | 0.00 | 0.00 | 88.25 |
| Ramos, Roberto, M,13159 | 208.18 | 0.00 | 0.00 | 0.00 | 208.18 |
| Hu, Amy,14320 | 261.95 | 0.00 | 0.00 | 0.00 | 261.95 |
| Li, Alvin,26764 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Raji, Warren, J,26796 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Andersen, Marshall, V,15786 | 4366.07 | 0.00 | 0.00 | 2049.10 | 2316.97 |
| Hernandez, Diana, F,11038 | 6437.33 | 3374.99 | 0.00 | 0.00 | 3062.34 |
| Ramos, Robyn, O,15828 | 172.25 | 0.00 | 0.00 | 49.96 | 122.29 |
| Srini, Candace,15437 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Sara, Ross,24367 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Rodriguez, Tammy,15233 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Yang, Valerie, L,27361 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Becker, Latoya, W,17330 | 30.97 | 0.00 | 0.00 | 21.98 | 8.99 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Shan, Drew,23659 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Dominguez, Walter,12576 | 2653.07 | 0.00 | 2049.10 | 0.00 | 603.97 |
| Malhotra, Marco, L,29459 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Tang, Sharon, M,15823 | 67.96 | 0.00 | 0.00 | 28.98 | 38.98 |
| Zhao, Marshall, C,22033 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Deng, Gilbert, C,15765 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Ruiz, Alberto, L,25212 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Ruiz, Gloria,12343 | 5567.93 | 0.00 | 2049.10 | 1223.84 | 2294.99 |
| Ms., Roy, Lisa, K.,21403 | 4895.69 | 0.00 | 2443.35 | 0.00 | 2452.34 |
| Alvarez, Francis,21552 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Andersen, Jaime,25268 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Gomez, Carrie,22965 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Pal, Mindy,19097 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
| Madan, Cory,26154 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Nath, Louis, C,25830 | 1833.57 | 0.00 | 699.10 | 0.00 | 1134.47 |
| Gill, Ricky, A,15607 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Xu, Kelsey, W,28220 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| She, Jenny,27586 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Subram, Meredith, S,14261 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Gao, Bianca, C,13112 | 5717.89 | 0.00 | 2049.10 | 0.00 | 3668.79 |
| Shen, Dustin,27974 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Williams, Alexis, D,14674 | 142.47 | 0.00 | 0.00 | 0.00 | 142.47 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 34.99 | 28.98 |
| Black, Michele,13995 | 64.97 | 0.00 | 0.00 | 34.99 | 29.98 |
| Mehta, Regina,17245 | 92.97 | 0.00 | 0.00 | 53.99 | 38.98 |
| Blanco, Wendy, J,19604 | 171.73 | 0.00 | 0.00 | 147.95 | 23.78 |
| 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 |
| Gao, Edwin,25716 | 1302.59 | 0.00 | 699.10 | 0.00 | 603.49 |
| Shen, Michele,27985 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Chande, Jerry,18331 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Barnes, Faith, F,15726 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| 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 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 4476.05 | 2413.06 |
| Lopez, Toni, K,25140 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Cai, Roger, A,13002 | 294.94 | 0.00 | 0.00 | 167.99 | 126.95 |
| Gao, Amy,21996 | 3946.52 | 0.00 | 2181.56 | 0.00 | 1764.96 |
| Cai, Jorge,22031 | 3896.53 | 0.00 | 2181.56 | 0.00 | 1714.97 |
| 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 |
| Zhou, Jamie,17327 | 99.94 | 0.00 | 0.00 | 0.00 | 99.94 |
| Moore, Lucas, J,15021 | 38.98 | 0.00 | 0.00 | 29.99 | 8.99 |
| Jai, Warren, S,16483 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Mr., Schmidt, Steve,15789 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Perez, Carmen, C,13139 | 6854.45 | 0.00 | 2071.42 | 0.00 | 4783.03 |
| Lopez, Savannah,25709 | 1308.06 | 699.10 | 0.00 | 0.00 | 608.96 |
| Shen, Misty, S,25019 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Alonso, Jimmy, T,18280 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| 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 |
| Reed, Kimberly, D,17311 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Suri, Gerald,13617 | 116.92 | 0.00 | 0.00 | 62.94 | 53.98 |
| Deng, Colleen, S,27728 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Ashe, Barbara,18734 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
Generated 2026-07-21 09:36:38.686 UTC