[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 814 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Summer,12036 | 69.55 | 0.00 | 0.00 | 0.00 | 69.55 |
| Alonso, Natasha, L,25009 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Shan, Tasha,15192 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Jiménez, Daisy,21944 | 4713.89 | 0.00 | 0.00 | 2181.56 | 2532.33 |
| Fernandez, Ross, R,11763 | 76.65 | 0.00 | 0.00 | 24.49 | 52.16 |
| Muñoz, Alberto, J,13008 | 125.51 | 0.00 | 0.00 | 0.00 | 125.51 |
| Vazquez, Marie,21899 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Gonzales, Lucas,29463 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Xu, Jaclyn, L,12685 | 6904.11 | 0.00 | 2049.10 | 0.00 | 4855.01 |
| Gao, Lisa, A,19753 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bailey, Sean, L,27710 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Zhu, Damien, M,15822 | 43.21 | 0.00 | 0.00 | 0.00 | 43.21 |
| Gao, Jon, C,11456 | 8224.46 | 0.00 | 3399.99 | 2391.43 | 2433.04 |
| Mr., Rodgers, Scott, M.,20211 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Martin, Jaime,28316 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gutierrez, Jaime, C,11457 | 8211.48 | 0.00 | 3374.99 | 0.00 | 4836.49 |
| Lal, Kara,22579 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nath, Bethany,16177 | 133.34 | 0.00 | 0.00 | 0.00 | 133.34 |
| Fernandez, Marie,28929 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanchez, Lydia, S,12579 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Alonso, Jonathon, A,15238 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Suri, Molly,17503 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Raman, Jermaine, E,15228 | 4375.06 | 0.00 | 0.00 | 2049.10 | 2325.96 |
| Tang, Drew, W,15178 | 4445.06 | 0.00 | 0.00 | 2049.10 | 2395.96 |
| Rubio, Larry,14223 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Andersen, Tara, L,24465 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Diaz, Marc,11058 | 8248.02 | 0.00 | 3399.99 | 2374.98 | 2473.05 |
| Tang, Cristina, D,19623 | 153.93 | 0.00 | 0.00 | 0.00 | 153.93 |
| Serrano, Mallory, E,26751 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Serrano, Alfredo,21258 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Jai, Drew, M,21562 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Ashe, Orlando, I,11897 | 8203.02 | 0.00 | 3399.99 | 0.00 | 4803.03 |
| Hernandez, Walter,13141 | 240.24 | 0.00 | 0.00 | 0.00 | 240.24 |
| Raji, Jaclyn,18289 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Ortega, Felicia, J,11753 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Alvarez, Randall,26750 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Wilson, Edward, L,26562 | 1925.41 | 0.00 | 0.00 | 782.99 | 1142.42 |
| Sanchez, Troy, H,25559 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Collins, Jennifer,11364 | 4921.82 | 0.00 | 3374.99 | 0.00 | 1546.83 |
| Becker, Julie,13614 | 114.21 | 0.00 | 0.00 | 0.00 | 114.21 |
| Rubio, Beth,20240 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Johnsen, Jerry,26670 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| She, Sharon, F,22017 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ma, Jorge, O,14052 | 86.26 | 0.00 | 0.00 | 27.28 | 58.98 |
| Rubio, Bruce, E,23343 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Xu, Sharon, A,23344 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Vazquez, Armando,22571 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
| Jackson, Joshua,17235 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Anand, Leonard,14316 | 3797.37 | 0.00 | 0.00 | 2049.10 | 1748.27 |
| Rubio, Mallory, S,11098 | 88.96 | 0.00 | 0.00 | 0.00 | 88.96 |
| Zhang, James,14684 | 38.55 | 0.00 | 0.00 | 0.00 | 38.55 |
| Yang, Crystal, A,23665 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Evans, Mason,15439 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Moreno, Naomi, C,15601 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Moreno, Lori, M,15226 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Ye, Jenny,25036 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Watson, Adrian, K,13641 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| West, James, M,15148 | 90.75 | 0.00 | 0.00 | 0.00 | 90.75 |
| Morgan, Melissa, M,20222 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Sanchez, Abby, J,19966 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Bell, Stephanie, A,27370 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Liang, Alan, L,29063 | 801.83 | 0.00 | 0.00 | 0.00 | 801.83 |
| Mitchell, Wyatt, A,14048 | 5123.74 | 0.00 | 0.00 | 2071.42 | 3052.32 |
| Shen, Russell, M,11150 | 192.42 | 0.00 | 0.00 | 0.00 | 192.42 |
| Alan, Bob, A,27366 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Andersen, Gilbert, T,27353 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Yuan, Sharon,12008 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Garcia, Tina,17231 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Li, Colin, J,18445 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Nara, Tonya, C,17251 | 123.96 | 0.00 | 0.00 | 69.97 | 53.99 |
| Xu, Tony, L,22576 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Andersen, Drew, K,22412 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Raje, Johnny,13975 | 5138.72 | 0.00 | 0.00 | 2049.10 | 3089.62 |
| Romero, Lance,18310 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sun, Todd,22018 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Suarez, Alfredo,19601 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Alexander, Elizabeth,13089 | 6800.45 | 0.00 | 0.00 | 2071.42 | 4729.03 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Chande, Franklin, L,20232 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Rana, Johnathan, R,27497 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Navarro, Janet, J,28320 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lin, Jeffery, J,27347 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Mr., Spencer, Phil,19960 | 6120.11 | 0.00 | 3578.27 | 0.00 | 2541.84 |
| Gao, Todd, M,11061 | 8129.02 | 0.00 | 3374.99 | 2369.96 | 2384.07 |
| Subram, Rebekah,26030 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lin, Margaret, C,18306 | 87.77 | 0.00 | 0.00 | 0.00 | 87.77 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Liang, Vincent,20402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nara, Michele, R,22842 | 86.46 | 0.00 | 0.00 | 0.00 | 86.46 |
| Powell, Kaitlyn,19598 | 5310.53 | 0.00 | 3578.27 | 0.00 | 1732.26 |
| Vazquez, Juan, P,22578 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Chander, Cassie, M,18258 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Patel, Gerald,23095 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramos, Kristy,16682 | 66.58 | 0.00 | 0.00 | 0.00 | 66.58 |
| Lu, Ronnie,19950 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Lopez, Deanna, L,25119 | 2148.21 | 0.00 | 0.00 | 1000.44 | 1147.77 |
| Hernandez, Erika,16160 | 2644.07 | 0.00 | 0.00 | 2049.10 | 594.97 |
| Navarro, Melinda,11454 | 8089.04 | 0.00 | 3374.99 | 2294.99 | 2419.06 |
| Deng, Tasha,11459 | 8141.33 | 0.00 | 3399.99 | 0.00 | 4741.34 |
| Black, Priscilla,15766 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Cooper, Katherine, R,14314 | 122.95 | 0.00 | 0.00 | 0.00 | 122.95 |
| Romero, Mallory,26434 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Munoz, Carolyn, L,17315 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Lin, Bianca,11107 | 8171.01 | 0.00 | 3374.99 | 2376.96 | 2419.06 |
| Chander, Bethany, K,11446 | 8237.01 | 0.00 | 3399.99 | 2354.98 | 2482.04 |
| Wu, Warren, M,15602 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Prasad, Candace, S,22148 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ma, Omar, I,15232 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Perez, Ivan, S,23408 | 4218.82 | 0.00 | 0.00 | 2443.35 | 1775.47 |
| Browning, Janet,19979 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Zhang, Cara,12351 | 117.97 | 0.00 | 0.00 | 0.00 | 117.97 |
| Patel, Deanna, H,27354 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| Hernandez, Jésus, M,24267 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Patel, Virginia, R,11366 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Arthur, Cassandra, M,22410 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Lin, Clarence,29069 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Jimenez, Felicia, L,11075 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
Generated 2025-12-22 02:29:51.838 UTC