[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 31 > TITLE Top 1000 Australian Internet customers for 2020
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 0.00 | 153.95 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 2318.96 | 2420.34 |
| Alvarez, Albert, R,16624 | 5938.25 | 3578.27 | 0.00 | 0.00 | 2359.98 |
| Jai, Warren, S,16483 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 1183.47 | 0.00 |
| Suarez, Jacquelyn, C,11010 | 8088.04 | 3399.99 | 0.00 | 2294.99 | 2393.06 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Thompson, Cameron, M,16620 | 5895.24 | 3578.27 | 0.00 | 0.00 | 2316.97 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 2297.28 | 2419.06 |
| Raman, Shane,16661 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Henderson, Xavier, K,12993 | 96.25 | 0.00 | 0.00 | 0.00 | 96.25 |
| Suri, Roy, M,17253 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Liu, Autumn, J,20985 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Price, Megan,24907 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Ms., Schultz, Barbara, R.,15811 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
| Hernandez, Max,18192 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Coleman, Melanie, H,15639 | 34.57 | 0.00 | 0.00 | 0.00 | 34.57 |
| Ashe, Joanna, F,20997 | 2744.52 | 0.00 | 2181.56 | 0.00 | 562.96 |
| Ma, Cedric, W,11094 | 157.93 | 0.00 | 0.00 | 0.00 | 157.93 |
| Gutierrez, Desiree,15216 | 101.74 | 0.00 | 0.00 | 27.28 | 74.46 |
| Kapoor, Regina,15810 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| Schmidt, Pamela, I,24375 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Jones, Nathan,15024 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Serrano, Darren,29196 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 2520.83 | 0.00 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
Generated 2025-11-02 17:55:10.323 UTC