[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 2625 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Guo, Tiffany,25927 | 1272.52 | 0.00 | 699.10 | 0.00 | 573.42 |
| Ferrier, Mathew,23426 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| He, Jessie,29094 | 796.34 | 0.00 | 0.00 | 0.00 | 796.34 |
| Mehta, Evelyn, S,20420 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Lopez, Kristi,28137 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
| Shen, Katie, A,20283 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Ma, Louis,21879 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Suarez, Neil,15242 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Suri, Jarrod, E,12004 | 8114.04 | 0.00 | 3374.99 | 0.00 | 4739.05 |
| Mr., Short, Carlos, M.,25139 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Saunders, Jillian,21178 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Zhou, Jessie,20610 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Johnson, Daniel,11051 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Rana, Stanley, J,22919 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 628.97 | 0.00 |
| Madan, Marco,18895 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
| Barnes, Angelica,15128 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Martin, Roy,22065 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Alvarez, Max, M,11986 | 8245.23 | 0.00 | 3399.99 | 0.00 | 4845.24 |
| Xu, Lindsey,15583 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Malhotra, Veronica, J,25922 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Luo, Shaun,27864 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Vazquez, Bruce, P,20417 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 0.00 | 4794.04 |
| Torres, Naomi, J,14061 | 82.26 | 0.00 | 0.00 | 32.27 | 49.99 |
| Navarro, Daisy,27514 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Dominguez, Ebony, R,17350 | 127.47 | 0.00 | 0.00 | 34.99 | 92.48 |
| Lin, Margaret, C,18306 | 87.77 | 0.00 | 0.00 | 0.00 | 87.77 |
| Madan, Rachael, R,16486 | 76.97 | 0.00 | 0.00 | 76.97 | 0.00 |
| Liu, Micah, J,15220 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Raje, April, R,18744 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Bhat, Yolanda,15225 | 4401.41 | 0.00 | 0.00 | 2071.42 | 2329.99 |
| Moore, Devin, J,16167 | 102.57 | 0.00 | 0.00 | 0.00 | 102.57 |
| Taylor, Devin, L,12248 | 3939.98 | 0.00 | 3399.99 | 0.00 | 539.99 |
| Madan, Raymond, W,20819 | 4181.76 | 0.00 | 3578.27 | 603.49 | 0.00 |
| Wang, Arturo, A,27720 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 0.00 | 2071.42 | 4789.02 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Sharma, Carl,21375 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Chapman, Jodi, L,22966 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Garcia, Charles, M,20250 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ramos, Adrienne, L,28216 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Scott, Alex, T,14348 | 2989.38 | 0.00 | 0.00 | 2071.42 | 917.96 |
| Goel, Gilbert,15596 | 4460.04 | 0.00 | 0.00 | 2049.10 | 2410.94 |
| White, Kayla,26424 | 79.47 | 0.00 | 0.00 | 79.47 | 0.00 |
| Xie, Kurt, A,14344 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Subram, Adriana,23424 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Weber, Jay, A,25244 | 21.93 | 0.00 | 0.00 | 21.93 | 0.00 |
| Gomez, Naomi, E,24300 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Rubio, Juan,16170 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Raji, Omar,15643 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Gonzalez, Francisco, L,12245 | 3967.26 | 0.00 | 3399.99 | 0.00 | 567.27 |
| Guo, Aimee,17075 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Lal, Mario, T,23345 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perez, Carmen, C,13139 | 6854.45 | 0.00 | 0.00 | 2071.42 | 4783.03 |
| Shen, Rafael, J,16689 | 290.46 | 0.00 | 0.00 | 0.00 | 290.46 |
| Gonzalez, Kaylee, L,21895 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Gill, Diane,15578 | 4509.90 | 0.00 | 0.00 | 2071.42 | 2438.48 |
| Raman, Johnathan,19103 | 63.91 | 0.00 | 0.00 | 41.93 | 21.98 |
| Liu, Omar, L,12252 | 3938.95 | 0.00 | 3374.99 | 0.00 | 563.96 |
| James, Mariah, M,19104 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| West, James, M,15148 | 90.75 | 0.00 | 0.00 | 59.48 | 31.27 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 0.00 | 4890.01 |
| Gomez, Brandi, M,14675 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Green, Jennifer,12571 | 2641.39 | 0.00 | 2071.42 | 0.00 | 569.97 |
| Russell, Jonathan,18896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Xu, Kathryn,25210 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sai, Kari, E,14231 | 83.97 | 0.00 | 0.00 | 24.99 | 58.98 |
| Lopez, Darren,29081 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Walker, Austin, F,20229 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Deng, Colin, B,18299 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Carlson, Alfredo,16178 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Black, Wayne, E,25056 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Dominguez, Walter,12576 | 2653.07 | 0.00 | 2049.10 | 0.00 | 603.97 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanchez, Michele,23543 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Ramos, Michele, J,19574 | 96.74 | 0.00 | 0.00 | 0.00 | 96.74 |
| Jones, Ethan,13051 | 6831.74 | 0.00 | 0.00 | 2071.42 | 4760.32 |
| Beck, Bonnie, A,29097 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Rai, Grant, R,12573 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Moreno, Hector,21183 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Raje, Wayne, A,21372 | 74.96 | 0.00 | 0.00 | 0.00 | 74.96 |
| He, Colin, B,14300 | 5322.73 | 0.00 | 0.00 | 2071.42 | 3251.31 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Sharma, Kelli,26672 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Henderson, Paige, C,17325 | 54.94 | 0.00 | 0.00 | 0.00 | 54.94 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Lal, Rafael, W,28945 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Gonzalez, Summer, L,20266 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Lopez, Terrance, T,14217 | 139.45 | 0.00 | 0.00 | 89.46 | 49.99 |
| Sanchez, Patrick, W,24382 | 143.78 | 0.00 | 0.00 | 0.00 | 143.78 |
| Nara, Yolanda,29080 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Randall, Toni,16605 | 66.26 | 0.00 | 0.00 | 27.28 | 38.98 |
| Raje, Derek,12574 | 2626.39 | 0.00 | 2071.42 | 0.00 | 554.97 |
| Nara, Katrina, Z,24608 | 2120.93 | 0.00 | 1000.44 | 1120.49 | 0.00 |
| Zhou, Stacey, L,21374 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Lu, Crystal, A,15145 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Suarez, Tabitha,25110 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Malhotra, Phillip, J,21977 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ruiz, Gloria,12343 | 5567.93 | 0.00 | 2049.10 | 0.00 | 3518.83 |
| Becker, Kara,21167 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Hayes, Christian, R,28537 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lopez, Stanley, M,28962 | 2477.53 | 0.00 | 0.00 | 0.00 | 2477.53 |
| Raji, Damien, K,24282 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Shan, Franklin, C,27718 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Sanchez, Candace, L,21567 | 4973.28 | 0.00 | 2443.35 | 0.00 | 2529.93 |
| Torres, Theresa,21202 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Sanz, Jimmy,25810 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Deng, Jodi,16161 | 2700.05 | 0.00 | 0.00 | 2049.10 | 650.95 |
| Rubio, Pedro, E,23098 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Ramos, Paula, W,21376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vance, Denise, L,21205 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Xu, Tonya,17324 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 778.62 | 0.00 |
| Richardson, Abigail, S,14236 | 5710.23 | 0.00 | 0.00 | 2071.42 | 3638.81 |
| Chandra, Carmen, R,23315 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Chandra, Dominique, H,26765 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| She, Eugene, L,20998 | 2806.51 | 0.00 | 2181.56 | 0.00 | 624.95 |
| Sanz, Walter, J,18195 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Alvarez, Adrienne, L,17067 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
Generated 2025-11-04 07:49:44.352 UTC