[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 438 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Lopez, Bruce,23540 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Jai, Kathryn,23546 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Jimenez, Melody, S,14066 | 3612.19 | 0.00 | 0.00 | 2853.57 | 758.62 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Beck, Ashlee, L,26666 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Lopez, Donald, A,26740 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Perez, Henry,26752 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Kumar, Warren, A,24003 | 2806.53 | 0.00 | 0.00 | 2181.56 | 624.97 |
| Munoz, Diane, R,15795 | 132.44 | 0.00 | 0.00 | 0.00 | 132.44 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Mehta, Heidi,14226 | 5656.24 | 0.00 | 0.00 | 2071.42 | 3584.82 |
| Raman, Arthur,24001 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Murphy, Grace, J,23655 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Perez, Joe, A,14326 | 5207.70 | 0.00 | 0.00 | 2071.42 | 3136.28 |
| Deng, Peter, A,24006 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Rai, Terrence, R,25037 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Fernandez, Lydia, M,14523 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Gao, Micah, W,25106 | 2170.92 | 0.00 | 0.00 | 1000.44 | 1170.48 |
| Fernandez, Rachael, M,23993 | 3072.32 | 0.00 | 0.00 | 2443.35 | 628.97 |
| Zimmerman, Candice, J,26754 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Lin, Jaclyn,28721 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Liang, Lacey, A,15719 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Taylor, Ashley, E,18215 | 150.97 | 0.00 | 0.00 | 0.00 | 150.97 |
| Navarro, Leslie, E,24371 | 4193.82 | 0.00 | 0.00 | 2443.35 | 1750.47 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Arun, Ross, C,23658 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Raman, César, C,24004 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Hernandez, Kristine,14286 | 5234.40 | 0.00 | 0.00 | 2049.10 | 3185.30 |
| Liu, Randy,15015 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Luo, Colleen, E,15208 | 2951.56 | 0.00 | 0.00 | 2049.10 | 902.46 |
| Lin, Jake,24248 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Jai, Tommy, C,15027 | 2853.57 | 0.00 | 0.00 | 2049.10 | 804.47 |
| Rana, Raymond,25115 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Gonzalez, Deanna, S,15204 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Suarez, Erika,15120 | 5217.70 | 0.00 | 0.00 | 2049.10 | 3168.60 |
| Raji, Warren, J,26796 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Chander, Drew, J,25111 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Chandra, Jarrod,24171 | 3006.31 | 0.00 | 0.00 | 2443.35 | 562.96 |
| Gonzalez, Joel, A,15043 | 3846.89 | 0.00 | 0.00 | 2071.42 | 1775.47 |
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| Mehta, Jay, S,15035 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Yang, Wesley, K,15127 | 5182.73 | 0.00 | 0.00 | 2071.42 | 3111.31 |
| Alonso, Renee,24166 | 2789.52 | 0.00 | 0.00 | 2181.56 | 607.96 |
| Luo, Lacey,24175 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Hu, Valerie, M,15044 | 3803.56 | 0.00 | 0.00 | 2049.10 | 1754.46 |
| Zeng, Amy,24242 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Serrano, Anne,24244 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Xu, Jaclyn,24252 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Hernandez, Mathew, A,15184 | 4441.38 | 0.00 | 0.00 | 2071.42 | 2369.96 |
| Dominguez, Roberto, A,26917 | 1339.25 | 0.00 | 0.00 | 782.99 | 556.26 |
| Perez, Bryant, L,15042 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Jimenez, Marie, C,24176 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Raji, Jaime, L,15037 | 3856.38 | 0.00 | 0.00 | 2071.42 | 1784.96 |
| Chen, Jon,26920 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Li, Edwin,26967 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Yang, Cedric,15038 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Andersen, Brendan,15121 | 5202.73 | 0.00 | 0.00 | 2071.42 | 3131.31 |
| Rai, Raul, R,15133 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Mr., Shen, Alan,24257 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Srini, Manuel,24168 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Sara, Clifford, M,24178 | 2810.53 | 0.00 | 0.00 | 2181.56 | 628.97 |
| Rai, Tasha, L,24301 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Srini, Darren, P,15591 | 4346.38 | 0.00 | 0.00 | 2049.10 | 2297.28 |
| Martin, Ebony, F,15223 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Barnes, Faith, F,15726 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| Chen, Clayton, A,15219 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Subram, Douglas,27352 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Suarez, Nelson,27355 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Prasad, Henry, M,24364 | 3965.52 | 0.00 | 0.00 | 2181.56 | 1783.96 |
| Zhu, Erica,25221 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Carlson, Theresa, L,19629 | 109.44 | 0.00 | 0.00 | 0.00 | 109.44 |
| Sun, Christy,25218 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Henderson, Alexia, M,15717 | 4411.37 | 0.00 | 0.00 | 2049.10 | 2362.27 |
| Gonzalez, Savannah, F,15644 | 3803.68 | 0.00 | 0.00 | 2071.42 | 1732.26 |
| Jiménez, Alberto, C,15215 | 4468.56 | 0.00 | 0.00 | 2049.10 | 2419.46 |
| Sai, Ruth, D,24461 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Jimenez, Jimmy,27365 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Madan, Roy,15716 | 4467.06 | 0.00 | 0.00 | 2049.10 | 2417.96 |
| Chow, Warren, L,24305 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Garcia, Roy, H,15585 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Raji, Damien, K,24282 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Liu, Micah, J,15220 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Goel, Gilbert,15596 | 4460.04 | 0.00 | 0.00 | 2049.10 | 2410.94 |
| Chander, Roger,25214 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Cooper, Alex, L,27362 | 1407.45 | 0.00 | 0.00 | 782.99 | 624.46 |
| Martinez, Monica, A,14129 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Zeng, Marshall, M,20987 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Powell, Grace, B,29194 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Martin, Randall, B,19560 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Garcia, Donald,18929 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Kumar, Kenneth,11472 | 8165.82 | 0.00 | 3399.99 | 0.00 | 4765.83 |
| Gill, Melinda, G,11151 | 8087.31 | 0.00 | 3374.99 | 0.00 | 4712.32 |
| Navarro, Marc,16346 | 37.55 | 0.00 | 0.00 | 0.00 | 37.55 |
| She, Latoya, A,11750 | 8148.02 | 0.00 | 3399.99 | 0.00 | 4748.03 |
| Stone, Colin, K,12673 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
| Yang, Shannon,12001 | 8113.01 | 0.00 | 3374.99 | 0.00 | 4738.02 |
| Brooks, Jared,24476 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Cox, Isaac,15797 | 4415.68 | 0.00 | 0.00 | 2071.42 | 2344.26 |
| Munoz, Sheila,27488 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Shan, Thomas, N,27483 | 1382.46 | 0.00 | 0.00 | 782.99 | 599.47 |
| Zheng, Barbara,27493 | 1353.46 | 0.00 | 0.00 | 782.99 | 570.47 |
| Sun, Jorge,16025 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Xu, Crystal, E,15754 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Guo, Rosa, M,24474 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| Ramos, Leslie,15733 | 4443.55 | 0.00 | 0.00 | 2049.10 | 2394.45 |
| He, Susan, A,24467 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Cooper, Cody, A,16028 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Torres, Monique,25235 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Sun, Dennis, K,24481 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Zhang, Kristen,27484 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Lin, Clayton, M,27492 | 1344.91 | 0.00 | 0.00 | 782.99 | 561.92 |
| Navarro, Eddie, C,24504 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Sharma, Lindsay, E,24478 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Rai, Tonya,25243 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Deng, Jodi,16161 | 2700.05 | 0.00 | 0.00 | 2049.10 | 650.95 |
| She, Tamara, M,14224 | 5621.22 | 0.00 | 0.00 | 2049.10 | 3572.12 |
| Shan, Johnny,11999 | 7043.27 | 0.00 | 3399.99 | 0.00 | 3643.28 |
| Munoz, Darren,23539 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Jai, Clayton,12339 | 6865.46 | 0.00 | 2071.42 | 0.00 | 4794.04 |
Generated 2025-12-22 02:32:47.499 UTC