[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 90 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Dominguez, Roy, C,29189 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Xie, Cristina, C,17050 | 4496.23 | 0.00 | 3578.27 | 0.00 | 917.96 |
| Romero, Meredith, J,29452 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Ye, Erica, E,13010 | 5716.52 | 0.00 | 0.00 | 2071.42 | 3645.10 |
| Patel, Jay,22213 | 59.27 | 0.00 | 0.00 | 0.00 | 59.27 |
| Mehta, Brett,11450 | 8173.26 | 0.00 | 3374.99 | 2370.22 | 2428.05 |
| Moreno, Mallory, P,22912 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Gomez, Marvin, C,28479 | 831.33 | 0.00 | 0.00 | 0.00 | 831.33 |
| Zhang, Jon,28111 | 865.31 | 0.00 | 0.00 | 0.00 | 865.31 |
| Diaz, Carolyn, C,24360 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Cai, Tiffany,18204 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Roberts, Jennifer,11447 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 0.00 | 193.97 |
| Cai, Gilbert, J,18256 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Xie, Wayne, S,18302 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Morris, Megan,23641 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Madan, Joe,29300 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Munoz, Shannon, S,29122 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Zhu, Alan,17320 | 4391.74 | 0.00 | 3578.27 | 0.00 | 813.47 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Xie, Ricardo,18710 | 6098.58 | 0.00 | 3578.27 | 0.00 | 2520.31 |
| Arthur, Regina, A,19089 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Black, Russell,18897 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Xu, Barbara,29195 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Patel, Douglas,17927 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
| Parker, Mason, W,25923 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Liang, Ronnie,24584 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Tang, Shawn,25832 | 1850.86 | 0.00 | 699.10 | 0.00 | 1151.76 |
| Gao, Erica, R,19087 | 47.20 | 0.00 | 0.00 | 36.96 | 10.24 |
| Subram, Martin, S,19590 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Sharma, Kelli,26672 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Andersen, Drew, K,22412 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Ramirez, Olivia, D,19785 | 6076.61 | 0.00 | 3578.27 | 0.00 | 2498.34 |
| Vazquez, Mallory, M,18283 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Diaz, Stacy, L,12340 | 6752.13 | 0.00 | 2049.10 | 0.00 | 4703.03 |
| Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Ortega, Linda, C,11756 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Shen, Franklin,27144 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Zhou, Arturo, F,27910 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Johnsen, Willie,15218 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Blanco, Orlando,22575 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Long, Megan, J,15791 | 42.26 | 0.00 | 0.00 | 0.00 | 42.26 |
| Scott, Alex, T,14348 | 2989.38 | 0.00 | 0.00 | 2071.42 | 917.96 |
| Ortega, Jill, A,20239 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Martin, Joan, R,25556 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Kapoor, Arthur,24483 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Chapman, Kristi, l,21986 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Lal, Deborah, T,21982 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 0.00 | 2482.23 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
Generated 2025-12-24 05:57:30.686 UTC