[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hernandez, Melody, E,28212 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Madan, Henry, E,17283 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Romero, Sabrina, L,28534 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Ye, Claudia, J,19102 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Martin, Jésus,28324 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
| Romero, Clinton, F,28132 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Rubio, Bruce, E,23343 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Chapman, Jodi, L,22966 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Ramos, Victor, D,24246 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Zimmerman, Jenny,18197 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Tang, Drew, W,15178 | 4445.06 | 0.00 | 0.00 | 2049.10 | 2395.96 |
| Luo, Mario, L,25711 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Raje, Lindsay, L,20613 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Diaz, Emma, L,18711 | 10.24 | 0.00 | 0.00 | 0.00 | 10.24 |
| Thompson, Justin,22954 | 4179.33 | 0.00 | 0.00 | 4179.33 | 0.00 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Wu, Shannon, F,15268 | 2840.91 | 0.00 | 0.00 | 2071.42 | 769.49 |
| Mehta, Brandy,22839 | 39.25 | 0.00 | 0.00 | 39.25 | 0.00 |
| Alvarez, Gloria, B,18297 | 6119.59 | 0.00 | 3578.27 | 2541.32 | 0.00 |
| Cox, Michelle, E,17328 | 4387.74 | 3578.27 | 0.00 | 0.00 | 809.47 |
| Vazquez, Jimmy, D,12348 | 6906.09 | 0.00 | 2049.10 | 0.00 | 4856.99 |
| Gao, Jake, A,19955 | 173.45 | 0.00 | 0.00 | 0.00 | 173.45 |
| Suarez, Leslie, C,22955 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gao, Wesley,12346 | 6864.46 | 0.00 | 2071.42 | 0.00 | 4793.04 |
| Pal, Tasha,22853 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Xu, Margaret, T,22404 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Serrano, Jacquelyn,21963 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Nelson, Sophia,16664 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Alvarez, Albert, R,16624 | 5938.25 | 3578.27 | 0.00 | 0.00 | 2359.98 |
| Thomas, Sydney,14322 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Goel, Dawn,23535 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Andersen, Warren,11919 | 8171.52 | 0.00 | 3374.99 | 0.00 | 4796.53 |
| Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
| Munoz, Gloria, L,19789 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Zhu, Wesley, L,19624 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Roberts, Jennifer,11447 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Green, Devin, J,26440 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Wang, Alan,13622 | 6841.43 | 0.00 | 0.00 | 2071.42 | 4770.01 |
| Martin, Ricky, C,16608 | 101.57 | 0.00 | 0.00 | 71.58 | 29.99 |
| Bradley, Victoria,29454 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Martin, Max, A,16030 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Martin, Tabitha,25269 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Martinez, Kari,19609 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Chen, Erica, P,18308 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 74.48 | 63.97 |
| She, Brittney, M,22942 | 3971.53 | 0.00 | 0.00 | 2181.56 | 1789.97 |
| Alvarez, Desiree,13005 | 223.97 | 0.00 | 0.00 | 0.00 | 223.97 |
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 75.97 | 0.00 |
| Barnes, Angelica,15128 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Zhang, Damien, C,26758 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Johnston, Joanna, L,17296 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Powell, Amanda,28113 | 901.35 | 0.00 | 0.00 | 0.00 | 901.35 |
| Martin, Craig, M,25012 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Ferrier, Jaclyn, D,17299 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Huang, Sandra, C,16523 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Alvarez, Stacy,11901 | 8248.01 | 0.00 | 3399.99 | 0.00 | 4848.02 |
| Jiménez, Briana, T,28118 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ramos, Albert, E,27716 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Serrano, Marvin, E,17316 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Subram, Raymond,23994 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Clark, Joshua, A,26137 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Rubio, Philip, P,21876 | 4663.38 | 0.00 | 2181.56 | 0.00 | 2481.82 |
| Madan, Evelyn, D,22582 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Yuan, Calvin,17905 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Munoz, Darren,23539 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 84.95 | 259.09 |
| Sanz, Marvin,19612 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Arun, Bryant, C,20453 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 71.58 | 34.98 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Yuan, Chad, C,21173 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Hill, Kaylee, L,11918 | 8204.99 | 0.00 | 3399.99 | 0.00 | 4805.00 |
| Perez, Carmen, C,13139 | 6854.45 | 0.00 | 0.00 | 2071.42 | 4783.03 |
| Yuan, Colin,11758 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Kumar, Tasha, M,20249 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Anand, Andrés,11096 | 8063.04 | 0.00 | 3374.99 | 2294.99 | 2393.06 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 2318.96 | 2420.34 |
| Blanco, Cheryl,13524 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Rodriguez, Heidi, L,25120 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Weber, Jarrod, M,14859 | 31.27 | 0.00 | 0.00 | 31.27 | 0.00 |
| Chen, Louis, J,17059 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Guo, Jake, P,19969 | 98.45 | 0.00 | 0.00 | 67.97 | 30.48 |
| Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 2181.56 | 0.00 | 563.77 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Hernandez, Leslie, D,12990 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 0.00 | 2071.42 | 4793.53 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Sara, Geoffrey,26188 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Gao, Amy,21996 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Chander, Alison,18249 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Chander, Russell, E,29067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| He, Aimee, A,11093 | 8180.00 | 0.00 | 3399.99 | 2360.95 | 2419.06 |
| Andersen, Drew, K,22412 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Subram, Ross, L,23085 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Suri, Shane, L,25126 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Xie, Kelli, J,20452 | 6156.70 | 0.00 | 3578.27 | 0.00 | 2578.43 |
| Jackson, Eduardo, C,11749 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| She, Latoya, A,11750 | 8148.02 | 0.00 | 3399.99 | 0.00 | 4748.03 |
| Huang, Margaret, H,17070 | 123.96 | 0.00 | 0.00 | 123.96 | 0.00 |
| Pal, Peter, K,22848 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Sharma, Julie, R,18191 | 94.47 | 0.00 | 0.00 | 8.99 | 85.48 |
| Romero, Ruben,16632 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Tang, Rafael, A,11908 | 8079.05 | 0.00 | 3374.99 | 2319.99 | 2384.07 |
| Rana, Johnathan, R,27497 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Dominguez, Micheal,26142 | 1952.45 | 0.00 | 782.99 | 0.00 | 1169.46 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 628.97 | 0.00 |
| Patel, Jay,22213 | 59.27 | 0.00 | 0.00 | 59.27 | 0.00 |
| Lu, Martha, R,21255 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
| Lal, Nicolas, D,21212 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Dominguez, Robin,16685 | 4183.23 | 3578.27 | 0.00 | 0.00 | 604.96 |
| She, Kelli, J,24889 | 2269.91 | 0.00 | 0.00 | 2269.91 | 0.00 |
| Garcia, Chelsea,21961 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Rodriguez, Geoffrey,20817 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Nath, Tommy, B,28937 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Blanco, Orlando,22575 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Zheng, Jenny, R,11947 | 4747.30 | 0.00 | 3374.99 | 629.96 | 742.35 |
Generated 2025-11-01 21:38:57.357 UTC