[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2750 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhang, Tiffany, R,17318 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Gutierrez, Kristine, G,25133 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Peterson, Allison, A,26421 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Gutierrez, Latasha, C,15022 | 2999.91 | 0.00 | 0.00 | 2071.42 | 928.49 |
| Hill, Alex, C,19787 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Garcia, Donald,18929 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Goel, Karla, L,11146 | 112.93 | 0.00 | 0.00 | 53.95 | 58.98 |
| Gonzalez, George, L,11942 | 4792.29 | 0.00 | 3399.99 | 614.96 | 777.34 |
| Fernandez, Lydia, M,14523 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Zhang, Ramon, D,12352 | 274.24 | 0.00 | 0.00 | 0.00 | 274.24 |
| Black, Shaun, M,17355 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Liang, Lacey, A,15719 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 0.00 | 61.58 |
| Ma, Warren, A,19762 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Shen, Rafael, J,16689 | 290.46 | 0.00 | 0.00 | 0.00 | 290.46 |
| Goel, Shawna, L,29332 | 165.28 | 0.00 | 0.00 | 0.00 | 165.28 |
| Anderson, Blake,11076 | 8159.04 | 0.00 | 3399.99 | 2374.98 | 2384.07 |
| Prasad, Cesar,23411 | 3577.82 | 0.00 | 0.00 | 3577.82 | 0.00 |
| Gao, Micah, W,25106 | 2170.92 | 0.00 | 0.00 | 1000.44 | 1170.48 |
| Powell, Kaitlyn,19598 | 5310.53 | 0.00 | 3578.27 | 0.00 | 1732.26 |
| Suarez, Dana, M,23541 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Lopez, Barry, R,26020 | 1932.46 | 0.00 | 782.99 | 0.00 | 1149.47 |
| Foster, Madison,14038 | 6819.12 | 0.00 | 0.00 | 2049.10 | 4770.02 |
| Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 2071.42 | 0.00 | 4768.04 |
| Ortega, Meghan, E,22004 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Luo, Warren,23562 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suarez, Billy, M,17287 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| Romero, Billy,20419 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Anna, L,20988 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Gomez, Derrick,18694 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Martinez, Kari,19609 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Chander, Misty,17333 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Sanchez, Lydia, S,12579 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 0.00 | 2181.56 | 1209.47 |
| Sanz, Julio, H,21404 | 4684.39 | 0.00 | 0.00 | 2181.56 | 2502.83 |
| Rodriguez, Jonathan, J,13046 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Mehta, Brandy,22839 | 39.25 | 0.00 | 0.00 | 39.25 | 0.00 |
| Liu, Brittney, M,15804 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Rai, Karl, M,25273 | 1898.07 | 0.00 | 699.10 | 0.00 | 1198.97 |
| Zheng, Dennis, E,25567 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Yang, Randy, E,24000 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Johnson, Daniel,11051 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Carson, Mitchell,13623 | 99.20 | 0.00 | 0.00 | 0.00 | 99.20 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Liu, Randy,15015 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Yang, Shannon,12001 | 8113.01 | 0.00 | 3374.99 | 0.00 | 4738.02 |
| Wood, Fernando, K,24253 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 0.00 | 4814.51 |
| Yang, Crystal, A,23665 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Cai, Willie, S,25960 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Navarro, Monique, R,15240 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Tang, Bridget,17730 | 4752.23 | 0.00 | 3578.27 | 0.00 | 1173.96 |
| She, Ricardo, A,14233 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Alvarez, Kendra, R,15267 | 2853.58 | 0.00 | 0.00 | 2049.10 | 804.48 |
| Blanco, Mallory,21958 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Hall, Jeremiah, M,18250 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Kumar, Karl, J,14218 | 5651.88 | 0.00 | 0.00 | 2049.10 | 3602.78 |
| Wang, Jon, A,26191 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Rana, Marco, K,24473 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 0.00 | 2492.32 |
| Moreno, Latasha, R,18735 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Carlson, Jill,21886 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Ramos, Danny,23121 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Ye, Alvin, B,15575 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Zhou, Autumn, L,25229 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Ortega, Tyrone, H,12583 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Alan, Bob, A,27366 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Xu, Peter, K,28204 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Stewart, Bryan, M,16928 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Sai, Terrance,19106 | 64.95 | 0.00 | 0.00 | 0.00 | 64.95 |
| Nara, Tony, L,16713 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Li, Jake, L,19583 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Mehta, Denise,13080 | 6844.41 | 0.00 | 0.00 | 2049.10 | 4795.31 |
| Lal, Karl, R,14264 | 5217.73 | 0.00 | 0.00 | 2822.76 | 2394.97 |
| Yuan, Bradley,17920 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Yang, Warren, F,17908 | 35.72 | 0.00 | 0.00 | 0.00 | 35.72 |
| Mehta, Michele,26143 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Sara, Phillip, R,25116 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramos, Jaime,15720 | 70.22 | 0.00 | 0.00 | 35.23 | 34.99 |
| Chen, Autumn, I,21408 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Ashe, Jimmy, S,28959 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 2049.10 | 1760.47 |
| Lewis, Jasmine,13964 | 6806.45 | 0.00 | 0.00 | 2071.42 | 4735.03 |
| Lopez, Rachael,23425 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Malhotra, Joel, E,16343 | 58.25 | 0.00 | 0.00 | 0.00 | 58.25 |
| Smith, Adriana,18702 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| She, Ashlee,28319 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Hernandez, Tabitha, L,19603 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Jai, Dylan, J,23128 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Romero, Desiree, J,17239 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Lin, Dennis,16169 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Chander, Devon,24612 | 2152.20 | 0.00 | 0.00 | 1000.44 | 1151.76 |
| Blanco, Kristi,15464 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Wright, Haley,26036 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Carlson, Robin,19786 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| He, Dennis, J,27878 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| Serrano, Javier, R,20256 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| King, Maria, E,28202 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Alvarez, Beth, M,29305 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Tang, Dawn, R,16496 | 5960.23 | 3578.27 | 0.00 | 0.00 | 2381.96 |
| Munoz, Marvin,14680 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Johnsen, Willie,15218 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Murphy, Alexa,18276 | 6106.60 | 0.00 | 3578.27 | 0.00 | 2528.33 |
| Andersen, Kelvin, C,21366 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Moreno, Marc,13024 | 2665.06 | 0.00 | 0.00 | 2049.10 | 615.96 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
| Li, Lacey,17515 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Zhao, Marshall, C,22033 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Alvarez, Max, M,11986 | 8245.23 | 0.00 | 3399.99 | 0.00 | 4845.24 |
| Kumar, Luke,24161 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 0.00 | 2071.42 | 3626.10 |
| Nara, Dawn, M,21891 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Bailey, Destiny, C,22941 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Hernandez, Melody, E,28212 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Prasad, Ebony,24368 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Richardson, Katelyn,18930 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Sanders, Devin, J,12014 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Raman, Patricia, T,16702 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Lu, Trisha,25555 | 1277.56 | 0.00 | 699.10 | 0.00 | 578.46 |
| He, Eugene, L,13645 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Rodriguez, Wyatt, D,21218 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
Generated 2025-12-17 17:50:05.459 UTC