[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL 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 | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sun, Jamie,21389 | 2770.52 | 0.00 | 2181.56 | 0.00 | 588.96 |
| Ross, Chloe, L,29404 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Martinez, Denise, L,12390 | 4977.86 | 0.00 | 0.00 | 4416.38 | 561.48 |
| Ruiz, Julio,11005 | 8121.33 | 3374.99 | 0.00 | 2362.27 | 2384.07 |
| Allen, Jason,15529 | 1587.47 | 0.00 | 0.00 | 782.99 | 804.48 |
| Zhang, Willie, T,16023 | 166.89 | 0.00 | 0.00 | 0.00 | 166.89 |
| Ruiz, Renee, L,26499 | 2848.76 | 0.00 | 0.00 | 2071.42 | 777.34 |
| Chander, Clarence, E,13982 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Lin, Mandy, C,25035 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Washington, Melanie,22898 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Zhou, Krystal,23593 | 3990.01 | 0.00 | 0.00 | 2181.56 | 1808.45 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 3355.24 | 2297.28 |
| Campbell, Gabriella,18841 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Perez, Toni,15581 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
| Raje, Tommy, E,17767 | 4101.76 | 0.00 | 0.00 | 1000.44 | 3101.32 |
| Campbell, Chloe,11212 | 827.19 | 0.00 | 0.00 | 231.72 | 595.47 |
| Gonzales, Sarah,13871 | 3060.52 | 0.00 | 0.00 | 3060.52 | 0.00 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Ye, Cedric, K,19335 | 1957.47 | 0.00 | 0.00 | 1957.47 | 0.00 |
| Xie, Drew, A,20218 | 104.69 | 0.00 | 0.00 | 0.00 | 104.69 |
| Flores, Jonathan, H,28615 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Watson, Timothy,29129 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Cox, Richard,17440 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cooper, Shelby,24740 | 96.07 | 0.00 | 0.00 | 0.00 | 96.07 |
| Ma, Ronnie, C,17815 | 3123.78 | 0.00 | 0.00 | 2443.35 | 680.43 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 0.00 | 286.82 |
| Henderson, Robert, K,27077 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Gao, Heather,19061 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Morgan, Garrett, J,18879 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Raje, Bridget, A,19433 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Cooper, Bryce, D,22096 | 133.47 | 0.00 | 0.00 | 0.00 | 133.47 |
| Hill, Gabriella,26364 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Russell, Mariah,13882 | 3282.81 | 0.00 | 0.00 | 3282.81 | 0.00 |
| Raji, Edwin,11469 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Kumar, Casey, G,12388 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| Chen, Samuel, D,22024 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Nath, Priscilla, H,21820 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raman, Ross,22529 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Murphy, Brian,20358 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Rai, Kelsey, L,19437 | 3480.38 | 0.00 | 0.00 | 3480.38 | 0.00 |
| Ramirez, Victoria,17418 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Li, Jack, J,14071 | 5617.92 | 0.00 | 0.00 | 2049.10 | 3568.82 |
| Yang, Stacey,14215 | 5665.89 | 0.00 | 0.00 | 2049.10 | 3616.79 |
| Mehta, Shane, S,23953 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Davis, Emily,27267 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Perez, Patricia,25022 | 1564.92 | 0.00 | 0.00 | 1000.44 | 564.48 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Flores, Taylor, W,27063 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Ward, Amanda,13714 | 3033.31 | 0.00 | 0.00 | 2443.35 | 589.96 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| Ross, Justin, J,14076 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Gutierrez, Jacquelyn, C,12384 | 5056.53 | 0.00 | 0.00 | 4478.07 | 578.46 |
| Patterson, Natalie,16123 | 629.97 | 0.00 | 0.00 | 0.00 | 629.97 |
| Jenkins, Melissa, R,15997 | 4746.34 | 0.00 | 0.00 | 0.00 | 4746.34 |
| Adams, Courtney, C,18075 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 |
| Kelly, Jade,27068 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Sanchez, Shane, A,17183 | 7175.86 | 0.00 | 0.00 | 2443.35 | 4732.51 |
| Edwards, Savannah,13367 | 4516.53 | 0.00 | 2181.56 | 0.00 | 2334.97 |
| Torres, Melinda, J,14033 | 6809.96 | 0.00 | 0.00 | 2071.42 | 4738.54 |
| Rogers, Eduardo, S,17544 | 2359.98 | 0.00 | 0.00 | 0.00 | 2359.98 |
| Prasad, Dominique, L,11432 | 9330.20 | 0.00 | 0.00 | 4401.40 | 4928.80 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Lal, Brandon,13883 | 3021.04 | 0.00 | 0.00 | 3021.04 | 0.00 |
| Martin, Justin,23542 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 2341.97 | 2507.03 |
| Perry, Olivia,20375 | 4438.38 | 0.00 | 0.00 | 2071.42 | 2366.96 |
| Jai, Kathryn,23546 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Rai, Yolanda,27047 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Alexander, James,26110 | 5759.06 | 0.00 | 3374.99 | 0.00 | 2384.07 |
| Harris, James, M,25064 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Stewart, Xavier,20645 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Hernandez, Deanna, R,17752 | 2776.41 | 0.00 | 0.00 | 1000.44 | 1775.97 |
| Thompson, Samantha, A,25075 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 |
| Cook, Mason, M,17614 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Lal, Austin, M,23066 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Lopez, Ivan,15553 | 1372.95 | 0.00 | 0.00 | 1372.95 | 0.00 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Patel, Lydia, B,29414 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Sanchez, Seth,17093 | 6917.59 | 0.00 | 0.00 | 2181.56 | 4736.03 |
| Andersen, Jerry,20975 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Vazquez, Julio, E,14969 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Gomez, Kathleen, J,16158 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Ashe, Barbara,18734 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Evans, Jason, P,23584 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ortega, Lawrence,14685 | 146.74 | 0.00 | 0.00 | 0.00 | 146.74 |
| Chapman, Shaun, K,12397 | 4968.04 | 0.00 | 0.00 | 4379.08 | 588.96 |
| Scott, Jordan, L,15535 | 3099.96 | 0.00 | 0.00 | 782.99 | 2316.97 |
| Raje, Johnny,13975 | 5138.72 | 0.00 | 0.00 | 2049.10 | 3089.62 |
| Dominguez, Eddie, O,17184 | 7253.35 | 0.00 | 0.00 | 2443.35 | 4810.00 |
| Wang, Todd,15676 | 7224.68 | 0.00 | 0.00 | 2443.35 | 4781.33 |
| Anand, Corey, E,16565 | 7203.66 | 0.00 | 0.00 | 2443.35 | 4760.31 |
| Wood, Angela, M,25348 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Dominguez, Clinton,15933 | 6931.88 | 0.00 | 2181.56 | 0.00 | 4750.32 |
| Vance, Veronica, G,16575 | 6994.57 | 0.00 | 0.00 | 2181.56 | 4813.01 |
| Yuan, Priscilla, L,17107 | 4179.33 | 0.00 | 0.00 | 4179.33 | 0.00 |
| Hill, Seth, M,25342 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Beck, Ashlee, L,26666 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Wright, Connor,20139 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Griffin, Fernando, J,23027 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Perez, Allen, B,14229 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Butler, Xavier, C,17698 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Brooks, Morgan, J,15548 | 1337.96 | 0.00 | 0.00 | 1337.96 | 0.00 |
| Collins, Dalton, M,14357 | 3337.71 | 0.00 | 0.00 | 1000.44 | 2337.27 |
| Dominguez, Kristine, A,14020 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Richardson, Melanie, M,13858 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Wood, Hannah,12717 | 5883.25 | 0.00 | 3578.27 | 0.00 | 2304.98 |
| Wang, Stacey,15689 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Lal, Franklin, A,14101 | 3679.90 | 0.00 | 0.00 | 2888.58 | 791.32 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Carlson, Walter,19943 | 3112.97 | 0.00 | 0.00 | 782.99 | 2329.98 |
| Edwards, Mackenzie, K,23458 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Gill, Walter,28975 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Sharma, Alicia, L,19440 | 3492.76 | 0.00 | 0.00 | 3492.76 | 0.00 |
| Luo, Marshall,19380 | 1934.75 | 0.00 | 0.00 | 1934.75 | 0.00 |
| Shan, Adam, A,28496 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lal, Robert, L,14084 | 138.68 | 0.00 | 0.00 | 0.00 | 138.68 |
| Howard, Michelle,23152 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Patterson, Julian, D,11840 | 87.28 | 0.00 | 0.00 | 0.00 | 87.28 |
| Blue, Makayla,19000 | 54.26 | 0.00 | 0.00 | 0.00 | 54.26 |
| Martinez, Rebekah, A,12721 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
Generated 2025-11-03 15:18:29.291 UTC