[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 318 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Vance, Denise, L,21205 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Nara, Tara,21194 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Chande, Tracy, J,12588 | 2639.08 | 0.00 | 0.00 | 2049.10 | 589.98 |
| Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Serrano, Alfredo,21258 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Liu, Cedric,12677 | 6785.47 | 0.00 | 0.00 | 2071.42 | 4714.05 |
| Jai, Michele, E,21225 | 4732.86 | 0.00 | 0.00 | 2181.56 | 2551.30 |
| Ms., Roy, Lisa, K.,21403 | 4895.69 | 0.00 | 0.00 | 2443.35 | 2452.34 |
| Henderson, Cassidy,21228 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Xu, Kelvin, K,21222 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Romero, Ricky,21361 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Travers, Jimmy, V,12674 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| King, Kevin, W,21402 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Sanz, Julio, H,21404 | 4684.39 | 0.00 | 0.00 | 2181.56 | 2502.83 |
| Zhou, Trisha, B,12686 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Ortega, Tyrone, H,12583 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Madan, Ann,21948 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Srini, Roy,24888 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Carlson, Jill,21886 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Thompson, Michael, M,26148 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Rana, Bryant,21878 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Zhang, Ramon, D,12352 | 274.24 | 0.00 | 0.00 | 0.00 | 274.24 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Fernandez, Ivan,22032 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 0.00 | 2071.42 | 4793.53 |
| Bhat, Edwin,13079 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Zhu, Louis,14858 | 196.97 | 0.00 | 0.00 | 0.00 | 196.97 |
| Foster, Madison,14038 | 6819.12 | 0.00 | 0.00 | 2049.10 | 4770.02 |
| Tang, Louis, A,18292 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Vazquez, Mallory, M,18283 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Bailey, Savannah, J,23428 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carlson, Theresa, L,19629 | 109.44 | 0.00 | 0.00 | 0.00 | 109.44 |
| Kumar, Warren, A,24003 | 2806.53 | 0.00 | 0.00 | 2181.56 | 624.97 |
| Gill, Jimmy,29098 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Mehta, Denise,13080 | 6844.41 | 0.00 | 0.00 | 2049.10 | 4795.31 |
| Zhu, Jessie, D,12666 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Moore, Sarah,28938 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Prasad, Brandy, P,14009 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Zhang, Susan, S,18216 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Rodriguez, Frederick, S,24458 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Rana, Meredith,25032 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Carlson, Jonathon, N,17073 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Lin, Claudia, A,14312 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Romero, Diane, F,21947 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Chander, Clarence, E,13982 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Lopez, Manuel, M,14050 | 5650.24 | 0.00 | 0.00 | 3295.26 | 2354.98 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Chen, Clarence, R,15147 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Goel, Michele,15041 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Anand, Tamara,29088 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Raman, César, C,24004 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Chander, Russell, E,29067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Hayes, Alexis,13048 | 190.23 | 0.00 | 0.00 | 0.00 | 190.23 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 0.00 | 60.05 |
| Gutierrez, Kari,15756 | 4441.39 | 0.00 | 0.00 | 2071.42 | 2369.97 |
| Jai, Lacey, C,11371 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Romero, Gary,22181 | 4673.88 | 0.00 | 0.00 | 2181.56 | 2492.32 |
| Goel, Roger, A,23652 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Cooper, Katherine, R,14314 | 122.95 | 0.00 | 0.00 | 0.00 | 122.95 |
| Munoz, Jimmy, E,21573 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
| Rubio, Mallory, S,11098 | 88.96 | 0.00 | 0.00 | 0.00 | 88.96 |
| Lal, Warren, B,25246 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Guo, Louis, D,15764 | 4413.39 | 0.00 | 0.00 | 2071.42 | 2341.97 |
| Pal, Terrence, M,13037 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Chapman, Jodi, L,22966 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Henderson, Isabella, L,21981 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Alvarez, Desiree,13005 | 223.97 | 0.00 | 0.00 | 0.00 | 223.97 |
| Torres, Eddie, L,21985 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Kumar, Cristina, N,15426 | 115.92 | 0.00 | 0.00 | 0.00 | 115.92 |
| Patel, Summer, G,26753 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Martinez, Terrance,25718 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Martin, Marc, J,11039 | 6636.58 | 0.00 | 3399.99 | 0.00 | 3236.59 |
| Raje, Lacey, T,12358 | 6787.76 | 0.00 | 0.00 | 2071.42 | 4716.34 |
| Rubio, Desiree, D,21189 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Stone, Denise,11032 | 6525.56 | 0.00 | 3374.99 | 0.00 | 3150.57 |
| Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
| Suarez, Neil,15242 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Pal, Nichole, J,26741 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Munoz, Casey, W,12570 | 2654.06 | 0.00 | 2049.10 | 0.00 | 604.96 |
| Alonso, Ricky, S,14070 | 5618.93 | 0.00 | 0.00 | 2049.10 | 3569.83 |
| Raje, Lindsey,24614 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Long, Emily, L,26140 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Rana, Nancy, H,26150 | 1992.46 | 0.00 | 0.00 | 782.99 | 1209.47 |
| Dominguez, Micheal,26142 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Chander, Latoya, C,26138 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Goel, Barbara,12988 | 6915.44 | 0.00 | 0.00 | 2049.10 | 4866.34 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 0.00 | 2049.10 | 3645.80 |
| Torres, Jacqueline,21976 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Chandra, Cynthia,22000 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Li, Alvin,26764 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Raji, Warren, J,26796 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Zhao, Crystal,25906 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ramos, Robyn, O,15828 | 172.25 | 0.00 | 0.00 | 0.00 | 172.25 |
| Srini, Candace,15437 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Malhotra, Veronica, J,25922 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Lu, Micah,22174 | 3007.83 | 0.00 | 0.00 | 2443.35 | 564.48 |
| Suarez, Kristy,21984 | 4175.61 | 0.00 | 0.00 | 2443.35 | 1732.26 |
| Cai, Jorge,22031 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Yuan, Jaclyn,24904 | 2199.90 | 0.00 | 0.00 | 1000.44 | 1199.46 |
| Nara, Grant,12995 | 6850.58 | 0.00 | 0.00 | 2049.10 | 4801.48 |
| Gutierrez, Gary, C,12701 | 6868.44 | 0.00 | 0.00 | 2071.42 | 4797.02 |
| Hernandez, Leslie, D,12990 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| Diaz, Kendra,13021 | 2668.38 | 0.00 | 0.00 | 2071.42 | 596.96 |
| Zeng, Dennis, S,13050 | 5651.25 | 0.00 | 0.00 | 2071.42 | 3579.83 |
| Torres, Kristy, M,13035 | 2638.06 | 0.00 | 0.00 | 2049.10 | 588.96 |
| Black, Tracy, B,24903 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Zhang, Clarence, M,13001 | 6799.43 | 0.00 | 0.00 | 2049.10 | 4750.33 |
| Perez, Ebony, M,24900 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Sai, Bruce,22194 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Garcia, Toni,22193 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Suri, Whitney, J,21974 | 4925.17 | 0.00 | 0.00 | 2443.35 | 2481.82 |
| Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
| Garcia, Virginia, C,24599 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Goel, Dawn,23535 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Luo, Christine, J,24159 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Vance, Kristopher, C,20407 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Subram, Candace,27585 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 0.00 | 3629.79 |
| Xu, Tony, L,22576 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Nara, Kelsey, A,24905 | 2195.91 | 0.00 | 0.00 | 1000.44 | 1195.47 |
| Morris, Isaac, G,26439 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Huang, Barbara,26442 | 1919.75 | 0.00 | 0.00 | 782.99 | 1136.76 |
Generated 2026-01-04 05:37:52.151 UTC