[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 625 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhou, Heather, M,24914 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Pal, Kara,24916 | 2169.90 | 0.00 | 0.00 | 1000.44 | 1169.46 |
| Shan, Carl, D,24919 | 2212.89 | 0.00 | 0.00 | 1000.44 | 1212.45 |
| Cai, Amy,24920 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Malhotra, Kristina,25031 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Nath, Carly, J,17255 | 4442.24 | 0.00 | 3578.27 | 0.00 | 863.97 |
| Browning, Jay, M,24251 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Stone, Colin, K,12673 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
| Blanco, Kristi,15464 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Carlson, Eddie,23347 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Sheena,23312 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Xu, Tasha, E,11948 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 0.00 | 2049.10 | 618.98 |
| Raje, Rafael, M,13000 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Shan, Shawna, K,27869 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| Shen, Cedric,22209 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Xu, Kara, E,22212 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Martinez, Cynthia,22170 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 2341.97 | 2507.03 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Sanchez, Carla,18274 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Rai, Nina,14018 | 63.87 | 0.00 | 0.00 | 0.00 | 63.87 |
| Stone, Brenda, J,12697 | 296.19 | 0.00 | 0.00 | 0.00 | 296.19 |
| Perez, Patricia,25022 | 1564.92 | 0.00 | 0.00 | 1000.44 | 564.48 |
| Navarro, Kellie, I,21873 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Henderson, Paige, C,17325 | 54.94 | 0.00 | 0.00 | 0.00 | 54.94 |
| Sharma, Kelli,26672 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Goel, Tonya,29123 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Serrano, Joanna, J,26663 | 1976.94 | 0.00 | 0.00 | 782.99 | 1193.95 |
| Li, Barbara,15788 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
| Liang, Amy,16164 | 2639.08 | 0.00 | 0.00 | 2049.10 | 589.98 |
| Ramos, Roy, A,24482 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Martin, Joe,14668 | 5216.69 | 0.00 | 0.00 | 2071.42 | 3145.27 |
| Chande, Mindy, V,27472 | 1345.95 | 0.00 | 0.00 | 782.99 | 562.96 |
| Tang, Nina,27485 | 1354.71 | 0.00 | 0.00 | 782.99 | 571.72 |
| Patel, Abby,16029 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Yang, Rosa,18713 | 237.26 | 0.00 | 0.00 | 0.00 | 237.26 |
| Kumar, Robert,25226 | 2158.90 | 0.00 | 0.00 | 1000.44 | 1158.46 |
| Kumar, Ricardo, K,14133 | 3764.07 | 0.00 | 0.00 | 2049.10 | 1714.97 |
| Deng, Gilbert, C,15765 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Sun, Suzanne, P,24587 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Raji, Corey,25058 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ferrier, Edwin, J,15757 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Gutierrez, Kari,15756 | 4441.39 | 0.00 | 0.00 | 2071.42 | 2369.97 |
| Rai, Melvin, J,24604 | 3681.80 | 0.00 | 0.00 | 3681.80 | 0.00 |
| Shen, Katrina,15801 | 4381.38 | 0.00 | 0.00 | 2049.10 | 2332.28 |
| Arun, Levi, A,11074 | 94.19 | 0.00 | 0.00 | 0.00 | 94.19 |
| Taylor, Christopher, E,21171 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Sanchez, Manuel,15126 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Perez, Stefanie,27518 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Fernandez, Carolyn, S,29302 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Cai, Bianca, D,22173 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Luo, Michele,26027 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Subram, Troy, R,19607 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Becker, Leonard, C,22405 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Jackson, Eduardo, C,11749 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Ruiz, Gloria,12343 | 5567.93 | 0.00 | 2049.10 | 0.00 | 3518.83 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 0.00 | 230.25 |
| Mehta, Denise,13080 | 6844.41 | 0.00 | 0.00 | 2049.10 | 4795.31 |
| Nara, Cassie,13642 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Kapoor, Dominic, J,16699 | 67.58 | 0.00 | 0.00 | 0.00 | 67.58 |
| Moreno, Randall, F,21209 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Carlson, Mathew, A,23012 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blanco, Lori, A,15735 | 116.25 | 0.00 | 0.00 | 0.00 | 116.25 |
| Nara, Tara,21194 | 3911.53 | 0.00 | 2181.56 | 0.00 | 1729.97 |
| Allen, Luis, C,26019 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Lal, Terry,18277 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Carlson, Audrey, A,25263 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Jimenez, Neil,22151 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Arun, Denise,28218 | 18.97 | 0.00 | 0.00 | 0.00 | 18.97 |
| Pal, Sheena, D,21197 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Hernandez, Jacquelyn, J,21568 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Nara, Leonard, G,11045 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Xu, Glenn,18743 | 67.21 | 0.00 | 0.00 | 0.00 | 67.21 |
| Chander, Cassie, M,18258 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Raje, Louis, M,25707 | 1262.06 | 0.00 | 699.10 | 0.00 | 562.96 |
| Raji, Kelli, G,13123 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
| She, Lindsay,29456 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Yuan, Colin,11758 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Chandra, Veronica,14681 | 5178.40 | 0.00 | 0.00 | 2049.10 | 3129.30 |
| Kennedy, Devon, J,13133 | 6813.12 | 0.00 | 0.00 | 2049.10 | 4764.02 |
| Vance, Marco,13124 | 87.93 | 0.00 | 0.00 | 0.00 | 87.93 |
| Lin, Jaclyn,28721 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cai, Trisha,18265 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Morris, Isaac, G,26439 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Shan, Colin,25921 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Alvarez, Tyrone, K,27693 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Hernandez, Jaime,24170 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Dominguez, Wendy,11035 | 6451.31 | 0.00 | 3374.99 | 0.00 | 3076.32 |
| Subram, Cory, B,27599 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Kovár, Whitney,13105 | 5585.45 | 0.00 | 0.00 | 2049.10 | 3536.35 |
| Zheng, Sandra, P,15141 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Suarez, Billy, M,17287 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| Tang, Christy, R,23660 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Saunders, Ruben, G,27983 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Carson, Terrence,11356 | 5069.29 | 0.00 | 3374.99 | 0.00 | 1694.30 |
| Serrano, Leslie, T,14014 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Raji, Devon, D,21898 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Subram, Stefanie,12371 | 214.04 | 0.00 | 0.00 | 0.00 | 214.04 |
| Chandra, Cynthia,22000 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Perez, Cesar, L,27982 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Gutierrez, Marvin,25938 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Dominguez, Micheal,26142 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Madan, Jarrod, C,21555 | 4715.49 | 0.00 | 0.00 | 2181.56 | 2533.93 |
| Kapoor, Cynthia,29457 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 0.00 | 2071.42 | 3626.10 |
| Jai, Tommy, C,15027 | 2853.57 | 0.00 | 0.00 | 2049.10 | 804.47 |
| Luo, Colleen, E,15208 | 2951.56 | 0.00 | 0.00 | 2049.10 | 902.46 |
| Raman, Virginia,26159 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Xie, Alvin, M,16617 | 160.55 | 0.00 | 0.00 | 69.97 | 90.58 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 2297.28 | 2419.06 |
| Carlson, Robin,19786 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Ruiz, Kari, L,12695 | 192.97 | 0.00 | 0.00 | 0.00 | 192.97 |
| Beck, Derek,17322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Chen, Jaclyn, C,22847 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Gray, Stephanie,17064 | 4506.76 | 0.00 | 3578.27 | 0.00 | 928.49 |
| Moreno, Tanya,11139 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Murphy, Grace, J,23655 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Yang, Tiffany, K,21215 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
Generated 2025-12-24 07:12:51.802 UTC