[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 750 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Flores, Noah,17256 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Martin, Lance,25236 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Srini, Manuel,24168 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Suarez, Melinda,29181 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Lal, Kate,21557 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Zheng, Shannon, M,14678 | 49.99 | 0.00 | 0.00 | 49.99 | 0.00 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 1205.47 | 0.00 |
| Serrano, Diane, E,14857 | 87.97 | 0.00 | 0.00 | 78.98 | 8.99 |
| Liang, Margaret,17254 | 147.48 | 0.00 | 0.00 | 93.49 | 53.99 |
| Lal, Julie, A,28309 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Sun, Mandy, L,16694 | 78.20 | 0.00 | 0.00 | 39.22 | 38.98 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 4.99 | 188.98 |
| Luo, Kenneth, S,15211 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Gonzalez, Roy, M,13040 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Lal, Leonard,26160 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Gao, Amy,21996 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Cai, Jorge,22031 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Green, Devin, J,26440 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Malhotra, Meredith,29314 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Richardson, Abigail, S,14236 | 5710.23 | 0.00 | 0.00 | 2071.42 | 3638.81 |
| Hernandez, Logan,12350 | 6791.75 | 0.00 | 2071.42 | 0.00 | 4720.33 |
| Shan, Jaime,22020 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Tang, Shawn,25832 | 1850.86 | 0.00 | 699.10 | 0.00 | 1151.76 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 34.89 | 45.22 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 7.95 | 34.98 |
| Liang, Rosa, L,19770 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Carlson, Armando,17484 | 126.96 | 0.00 | 0.00 | 21.98 | 104.98 |
| Chande, Warren,17307 | 132.95 | 0.00 | 0.00 | 132.95 | 0.00 |
| Anand, Andrés,11096 | 8063.04 | 0.00 | 3374.99 | 2294.99 | 2393.06 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 21.98 | 68.97 |
| Li, Kristen, R,15153 | 113.97 | 0.00 | 0.00 | 88.98 | 24.99 |
| Sun, Karen, C,28208 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| 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 |
| Barnes, Isabella, J,25239 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| 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 |
| Prasad, Tabitha, D,26761 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Jai, Warren, S,16483 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Mehta, Levi, M,13110 | 5583.94 | 0.00 | 0.00 | 2049.10 | 3534.84 |
| Ferrier, Jenny,21955 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Blanco, Mallory,21958 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Zhao, Alisha, M,21988 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| She, Roger, L,15724 | 4359.07 | 0.00 | 0.00 | 2049.10 | 2309.97 |
| Sanz, Orlando,14309 | 99.47 | 0.00 | 0.00 | 74.48 | 24.99 |
| Xie, Marshall, M,19796 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Smith, Adriana,18702 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Cox, Jared, E,28114 | 570.47 | 0.00 | 0.00 | 570.47 | 0.00 |
| Madan, Jay, L,20156 | 4139.75 | 0.00 | 3578.27 | 561.48 | 0.00 |
| Gao, Arturo,28714 | 2433.04 | 0.00 | 0.00 | 2433.04 | 0.00 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 2484.94 | 0.00 |
| Zeng, Heather, E,18287 | 72.16 | 0.00 | 0.00 | 72.16 | 0.00 |
| Zhang, Suzanne, R,20316 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Martin, Roy,22065 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| He, Colin, B,14300 | 5322.73 | 0.00 | 0.00 | 2071.42 | 3251.31 |
| Zeng, Stacey, J,17317 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Kumar, Derek, M,15135 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 |
| Pal, Mohamed, D,12698 | 6786.75 | 0.00 | 2071.42 | 0.00 | 4715.33 |
| Li, Lisa, J,24600 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 2297.28 | 2419.06 |
| Williams, Wyatt, E,19614 | 6217.21 | 0.00 | 3578.27 | 0.00 | 2638.94 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Madan, Erick, W,14212 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Ramos, Meredith, A,23307 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Arun, Barry,27700 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Romero, Dwayne,28314 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Moreno, Felicia, A,12987 | 6759.47 | 0.00 | 0.00 | 2071.42 | 4688.05 |
| He, Curtis, D,24921 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Jimenez, Victor,11461 | 8089.04 | 0.00 | 3374.99 | 2294.99 | 2419.06 |
| Torres, Naomi, J,14061 | 82.26 | 0.00 | 0.00 | 32.27 | 49.99 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 77.96 | 37.97 |
| Ma, Lacey, K,18723 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Serrano, Linda,11071 | 110.23 | 0.00 | 0.00 | 42.26 | 67.97 |
| Hernandez, Clinton,29462 | 854.82 | 0.00 | 0.00 | 0.00 | 854.82 |
| Gutierrez, Gary, C,12701 | 6868.44 | 0.00 | 0.00 | 2071.42 | 4797.02 |
| Williams, Madison, J,21198 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Wilson, Zachary,25558 | 1307.06 | 699.10 | 0.00 | 0.00 | 607.96 |
| Li, Cedric,27364 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Lin, Laura, L,11462 | 8116.33 | 0.00 | 3374.99 | 2322.28 | 2419.06 |
| Sharma, Carl,21375 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Ramos, Adrienne, L,28216 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| Liu, Steve, V,23523 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Weber, Jay, A,25244 | 21.93 | 0.00 | 0.00 | 21.93 | 0.00 |
| Fernandez, Ronald,28939 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Suri, Gerald,13617 | 116.92 | 0.00 | 0.00 | 0.00 | 116.92 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 0.00 | 2443.35 | 1725.98 |
| Goel, Chad,28219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2071.42 | 1581.81 |
| Tang, Louis, A,18292 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Gao, Jamie,26022 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Navarro, Sheila, L,21889 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Liu, Jaclyn,12996 | 6808.15 | 0.00 | 0.00 | 2049.10 | 4759.05 |
| Ashe, Katie, Z,26770 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Liu, Darryl,19947 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Nara, Grant,12995 | 6850.58 | 0.00 | 0.00 | 2049.10 | 4801.48 |
| She, Jaime, D,28482 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Coleman, Melanie, H,15639 | 34.57 | 0.00 | 0.00 | 0.00 | 34.57 |
| Carter, Sophia, D,25230 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Vazquez, Arthur,28480 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Anand, Lacey, J,27150 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Rana, Joe, D,11916 | 8178.51 | 0.00 | 3374.99 | 2405.47 | 2398.05 |
| Anand, Katrina, L,18726 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Mehta, Evelyn, S,20420 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Powell, Alexis, M,23531 | 3337.28 | 0.00 | 0.00 | 3337.28 | 0.00 |
| Rubio, Marie, V,20618 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Beck, Alisha, E,11463 | 47.92 | 0.00 | 0.00 | 7.95 | 39.97 |
| Rana, Jermaine, S,28927 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Torres, Marc,11765 | 8143.03 | 0.00 | 3374.99 | 2294.99 | 2473.05 |
| Perez, Brenda,11899 | 8189.50 | 0.00 | 3374.99 | 2395.45 | 2419.06 |
| Perez, Ebony, M,24900 | 2155.92 | 0.00 | 0.00 | 2155.92 | 0.00 |
| Munoz, Kendra, S,23529 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
| Martin, Adrienne,19952 | 39.46 | 0.00 | 0.00 | 25.48 | 13.98 |
| Suri, Mayra, M,15729 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 |
| Rodriguez, Bobby,15752 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Serrano, Randall,27973 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gutierrez, Pedro, S,15224 | 71.92 | 0.00 | 0.00 | 0.00 | 71.92 |
| Foster, Aidan,26445 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Patel, Bryant, L,27969 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Andersen, Calvin,22920 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 2443.35 | 0.00 | 2482.23 |
| Li, David, A,21894 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
Generated 2025-11-07 02:36:19.976 UTC