[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 1750 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zeng, Cara,20444 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Shen, Lindsey,26560 | 1396.44 | 0.00 | 0.00 | 782.99 | 613.45 |
| Chander, Latoya, C,26138 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Coleman, Brittany,15579 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Chapman, Alicia, A,21418 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 0.00 | 104.96 |
| Cai, Gilbert, J,18256 | 98.96 | 0.00 | 0.00 | 63.97 | 34.99 |
| She, Keith, L,26563 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Zheng, Jeffery, W,15030 | 3786.39 | 0.00 | 0.00 | 2071.42 | 1714.97 |
| Stone, Brenda, J,12697 | 296.19 | 0.00 | 0.00 | 0.00 | 296.19 |
| Simpson, Tara, K,28107 | 810.32 | 0.00 | 0.00 | 810.32 | 0.00 |
| Raman, Raymond, R,19588 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Sara, Geoffrey,26188 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Gonzalez, Summer, L,20266 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Carlson, Marc, W,17501 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Zhao, Randy, J,27874 | 1288.31 | 0.00 | 0.00 | 1288.31 | 0.00 |
| Cai, Jorge,22031 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Schmidt, Pamela, I,24375 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Andersen, Mitchell, H,25026 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Gutierrez, Kari,15756 | 4441.39 | 0.00 | 0.00 | 2071.42 | 2369.97 |
| Lal, Shaun, H,17056 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Xie, Cristina, C,17050 | 4496.23 | 3578.27 | 0.00 | 0.00 | 917.96 |
| Li, Stacey,14064 | 5694.21 | 0.00 | 0.00 | 2071.42 | 3622.79 |
| Nara, Tommy,16729 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Sanz, Francis,12577 | 2614.08 | 0.00 | 2049.10 | 0.00 | 564.98 |
| Raman, Harold, F,28484 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Sanz, Marvin,19612 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Nelson, Sophia,16664 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Carlson, Tanya,16183 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Xu, Cedric,18198 | 4143.25 | 0.00 | 3578.27 | 0.00 | 564.98 |
| Shan, Derek, R,19782 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Alonso, Meredith, M,20621 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Andersen, Marshall, V,15786 | 4366.07 | 0.00 | 0.00 | 2049.10 | 2316.97 |
| Rana, Meredith,25032 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Rai, Brendan, A,21569 | 4960.16 | 0.00 | 2443.35 | 0.00 | 2516.81 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 23.78 | 36.27 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 2297.28 | 2419.06 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 186.94 | 0.00 |
| Jackson, Eduardo, C,11749 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Perez, Preston,12370 | 61.53 | 0.00 | 0.00 | 34.56 | 26.97 |
| Carlson, Philip, P,11915 | 8143.00 | 0.00 | 3374.99 | 2369.96 | 2398.05 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Suarez, Jacquelyn, C,11010 | 8088.04 | 3399.99 | 0.00 | 2294.99 | 2393.06 |
| Yang, Louis, J,23013 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Kapoor, Jarrod,28930 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Serrano, Beth,24304 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Lopez, Carla, G,28326 | 2442.54 | 0.00 | 0.00 | 2442.54 | 0.00 |
| Alvarez, Mathew, L,17494 | 111.96 | 0.00 | 0.00 | 0.00 | 111.96 |
| Dominguez, Andy, L,14126 | 135.55 | 0.00 | 0.00 | 63.97 | 71.58 |
| Sun, Louis, E,16182 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Clark, Madison, A,14062 | 5647.92 | 0.00 | 0.00 | 3272.94 | 2374.98 |
| Sullivan, Toni, M,29083 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Perez, Molly,25941 | 1255.36 | 0.00 | 699.10 | 0.00 | 556.26 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Reed, Riley, A,20157 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| She, Kelli, J,24889 | 2269.91 | 0.00 | 0.00 | 2269.91 | 0.00 |
| Sun, Mandy, L,16694 | 78.20 | 0.00 | 0.00 | 39.22 | 38.98 |
| Zheng, Colleen,13026 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Perez, Janelle,16172 | 186.04 | 0.00 | 0.00 | 0.00 | 186.04 |
| Zheng, Roger,29321 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Garcia, Martin, l,23332 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Patel, Toni, E,25829 | 1894.07 | 0.00 | 699.10 | 0.00 | 1194.97 |
| Kumar, Shawna, L,19085 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Diaz, Cheryl, A,11092 | 8110.02 | 0.00 | 3374.99 | 2341.97 | 2393.06 |
| Malhotra, Janelle,26425 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Yang, Randy, E,24000 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Ma, Christy,15020 | 40.26 | 0.00 | 0.00 | 0.00 | 40.26 |
| Lee, Grace, J,28318 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Garcia, Charles, M,20250 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Chandra, Veronica,14681 | 5178.40 | 0.00 | 0.00 | 2049.10 | 3129.30 |
| Yuan, Kelsey, D,13034 | 94.71 | 0.00 | 0.00 | 0.00 | 94.71 |
| Chapman, Preston, O,18268 | 6102.19 | 0.00 | 3578.27 | 0.00 | 2523.92 |
| Blanco, Lee, M,16660 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Davis, Nicole,22957 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhu, Tiffany,26437 | 1953.47 | 0.00 | 0.00 | 782.99 | 1170.48 |
| Pal, Derek,24591 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Cai, Alvin, D,11115 | 35.23 | 0.00 | 0.00 | 27.28 | 7.95 |
| Pal, Sheena, D,21197 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Sara, Tina,24307 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 0.00 | 1000.44 | 1179.47 |
| Gao, Louis,14666 | 5199.92 | 0.00 | 0.00 | 2049.10 | 3150.82 |
| She, Nichole, M,11909 | 8105.31 | 0.00 | 3374.99 | 2297.28 | 2433.04 |
| Green, Sydney,23522 | 120.47 | 0.00 | 0.00 | 0.00 | 120.47 |
| Sharma, Bonnie, R,25562 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Diaz, Carolyn, C,24360 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Munoz, Natasha, M,24601 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Lal, Terry,18277 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Srini, Jay, M,18326 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Raje, Jodi, E,19630 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Romero, Philip, F,22195 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Ma, Omar, I,15232 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Sanders, Gabriella,11906 | 8151.00 | 0.00 | 3374.99 | 2391.94 | 2384.07 |
| Blanco, Victor,15586 | 4469.37 | 0.00 | 0.00 | 2071.42 | 2397.95 |
| Shen, Leonard, J,24271 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Luo, Bethany,19582 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Kapoor, Brandy, I,15236 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Martin, Randall, B,19560 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Serrano, Dana, S,12678 | 341.43 | 0.00 | 0.00 | 89.46 | 251.97 |
| Jimenez, Neil,22151 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Subram, Cassandra, M,16618 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Xu, Edwin, J,25272 | 1873.58 | 699.10 | 0.00 | 0.00 | 1174.48 |
| Carlson, Jill,21886 | 4696.49 | 0.00 | 2181.56 | 0.00 | 2514.93 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Rubio, Jay,15179 | 4444.89 | 0.00 | 0.00 | 2071.42 | 2373.47 |
| Nath, Jaime,11033 | 6495.29 | 3374.99 | 0.00 | 0.00 | 3120.30 |
| Jai, Nichole, R,28348 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 1183.47 | 0.00 |
| Prasad, Dominic, D,19962 | 46.75 | 0.00 | 0.00 | 0.00 | 46.75 |
| Sanchez, Carla,18274 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Luo, Warren,23562 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hall, Jeremiah, M,18250 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Sanchez, Manuel,15126 | 86.26 | 0.00 | 0.00 | 58.98 | 27.28 |
| Gao, Wesley,12346 | 6864.46 | 0.00 | 2071.42 | 0.00 | 4793.04 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 0.00 | 4828.51 |
| Diaz, Ruben, A,25136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zeng, Ramon,27979 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yang, Colin, J,20612 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Lu, Sandra, N,13521 | 4514.77 | 0.00 | 0.00 | 4514.77 | 0.00 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 0.00 | 2071.42 | 4753.31 |
| Shen, Tony,29099 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Lin, Kelli, A,21392 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Chandra, Arthur, L,14032 | 6859.43 | 0.00 | 0.00 | 2071.42 | 4788.01 |
| Madan, Kristopher, A,25238 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Generated 2025-11-04 07:49:18.553 UTC