[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raman, Michele,17233 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Mehta, Michele,26143 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Gutierrez, Larry,25926 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Li, Margaret,15753 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Blanco, Natasha,15808 | 4424.08 | 0.00 | 0.00 | 2049.10 | 2374.98 |
| Ma, Christy,15020 | 40.26 | 0.00 | 0.00 | 0.00 | 40.26 |
| Carlson, Billy, C,19667 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Gao, Christy, D,26204 | 1967.45 | 0.00 | 0.00 | 782.99 | 1184.46 |
| Diaz, Gerald, M,25118 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Garcia, Darren,28716 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Subram, Cassandra, M,16618 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| She, Nichole, M,11909 | 8105.31 | 0.00 | 3374.99 | 2297.28 | 2433.04 |
| Jimenez, Erik, H,21989 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Rodriguez, Ruth, R,26179 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Raji, Christy,15584 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Huang, Arturo,28952 | 2473.04 | 0.00 | 0.00 | 2473.04 | 0.00 |
| Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 0.00 | 104.96 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 0.00 | 3175.80 |
| Yang, Alejandro, M,22176 | 100.46 | 0.00 | 0.00 | 0.00 | 100.46 |
| Vazquez, Krista,26164 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhang, Roger,12690 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Madan, Bruce, G,18206 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Zheng, Cara, L,27513 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Zheng, Shannon, M,14678 | 49.99 | 0.00 | 0.00 | 49.99 | 0.00 |
| Patel, Ann,21371 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zeng, Jon, O,14310 | 5200.66 | 0.00 | 0.00 | 2071.42 | 3129.24 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Perez, Ross, E,14307 | 196.26 | 0.00 | 0.00 | 159.00 | 37.26 |
| Raman, Sergio,27866 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Ward, Katelyn,20258 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Gomez, Kendra, J,23320 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Serrano, Shannon, R,18303 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Gomez, Andy,18721 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Lin, Darryl, J,15031 | 41.27 | 0.00 | 0.00 | 32.28 | 8.99 |
| Li, Wesley,23322 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 1205.47 | 0.00 |
| Ramos, Jessie, R,11764 | 8129.02 | 0.00 | 3399.99 | 0.00 | 4729.03 |
| Xu, Tonya,17324 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Moyer, Mario,23420 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Li, Dawn, B,13962 | 40.22 | 0.00 | 0.00 | 40.22 | 0.00 |
| Kapoor, Brandy, I,15236 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Madan, Evelyn, D,22582 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Gray, Jeremiah,23331 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Liang, Margaret,17254 | 147.48 | 0.00 | 0.00 | 93.49 | 53.99 |
| Ortega, Shannon,26375 | 1971.45 | 0.00 | 0.00 | 782.99 | 1188.46 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Guo, Margaret,23431 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| She, Marshall, D,18707 | 122.76 | 0.00 | 0.00 | 120.47 | 2.29 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Carlson, Philip, P,11915 | 8143.00 | 0.00 | 3374.99 | 2369.96 | 2398.05 |
| Liu, Lacey, L,23545 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Zhu, Vincent, E,24899 | 105.45 | 0.00 | 0.00 | 105.45 | 0.00 |
| Lopez, Toni, K,25140 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Hernandez, Erik, C,21998 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Chander, Marshall,19090 | 59.26 | 0.00 | 0.00 | 2.29 | 56.97 |
| Green, Devin, J,26440 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Gao, Jake, A,19955 | 173.45 | 0.00 | 0.00 | 0.00 | 173.45 |
| Patel, Jillian,26667 | 1390.95 | 0.00 | 0.00 | 1390.95 | 0.00 |
| Torres, Bailey,18259 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Guo, Alisha, P,23571 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Reed, Kimberly, D,17311 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Powell, Alexis, M,23531 | 3337.28 | 0.00 | 0.00 | 3337.28 | 0.00 |
| Lal, Julie, A,28309 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Huang, Omar, C,14232 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Chandra, Arthur, L,14032 | 6859.43 | 0.00 | 0.00 | 2071.42 | 4788.01 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 4.99 | 188.98 |
| Gonzalez, Ivan, C,19625 | 52.77 | 0.00 | 0.00 | 0.00 | 52.77 |
| Suri, Lydia,13126 | 6815.08 | 0.00 | 0.00 | 2049.10 | 4765.98 |
| Shen, Roger, G,14011 | 3831.89 | 0.00 | 0.00 | 3831.89 | 0.00 |
| Yuan, Jon,25937 | 1299.56 | 0.00 | 699.10 | 0.00 | 600.46 |
| Lopez, Virginia, J,27338 | 1339.92 | 0.00 | 0.00 | 782.99 | 556.93 |
| Carlson, Marie,29311 | 603.96 | 0.00 | 0.00 | 0.00 | 603.96 |
| Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
| Jai, Lacey, C,11371 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ashe, Tara, J,19093 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Suarez, Hector, L,15034 | 103.45 | 0.00 | 0.00 | 8.99 | 94.46 |
| Sanz, Cheryl, G,14046 | 5645.24 | 0.00 | 0.00 | 3340.26 | 2304.98 |
| Gill, Jaime, M,26152 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Schmidt, Kaitlin,13628 | 191.25 | 0.00 | 0.00 | 0.00 | 191.25 |
| Alonso, Kathleen,21196 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Rivera, Nathaniel, M,14051 | 5606.91 | 0.00 | 0.00 | 3286.92 | 2319.99 |
| Xie, Nina,12997 | 118.18 | 0.00 | 0.00 | 0.00 | 118.18 |
| Shen, Calvin, W,26145 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Yang, Cedric,15038 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Munoz, Tanya,23436 | 3950.52 | 0.00 | 0.00 | 2181.56 | 1768.96 |
| Dominguez, Theodore, F,21987 | 4638.89 | 0.00 | 0.00 | 2181.56 | 2457.33 |
| Xu, Clayton, W,25001 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Serrano, Joy, L,14069 | 173.94 | 0.00 | 0.00 | 0.00 | 173.94 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 3809.57 | 0.00 |
| Mehta, Cassandra,23014 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ramos, Eddie, T,13954 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Torres, Theresa,21202 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Wang, Nathan,14039 | 6808.13 | 0.00 | 0.00 | 2049.10 | 4759.03 |
| Adams, Sydney,27367 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Deng, Peter, A,24006 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Jiménez, Brandi,24378 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Vazquez, Marc, H,24362 | 3600.77 | 0.00 | 0.00 | 2443.35 | 1157.42 |
| Yang, Connor,17735 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| West, Nathan,24370 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Li, Cara,27587 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Malhotra, Kristina,25031 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Raji, Katrina, M,16517 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Zhang, Warren, L,25252 | 1893.05 | 699.10 | 0.00 | 0.00 | 1193.95 |
| Suri, Mayra, M,15729 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 |
| Pal, Alvin, C,29319 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Sharma, Terrence, N,17351 | 6117.69 | 3578.27 | 0.00 | 0.00 | 2539.42 |
| Zhu, Suzanne, E,25112 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Subram, Stefanie,12371 | 214.04 | 0.00 | 0.00 | 0.00 | 214.04 |
| Munoz, Robyn,14214 | 5759.87 | 0.00 | 0.00 | 2049.10 | 3710.77 |
| Mehta, Deanna, P,17280 | 6089.59 | 3578.27 | 0.00 | 0.00 | 2511.32 |
| Carson, Bradley,23995 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Hernandez, Walter,13141 | 240.24 | 0.00 | 0.00 | 0.00 | 240.24 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Fernandez, Nancy,14854 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Foster, Aidan,26445 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Kumar, Jenny, C,23429 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Vazquez, Daisy, L,25560 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Alvarez, Max, M,11986 | 8245.23 | 0.00 | 3399.99 | 0.00 | 4845.24 |
| Liu, Steve, V,23523 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
Generated 2025-11-04 07:44:30.570 UTC