[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1250 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martin, Felicia, L,15018 | 112.46 | 0.00 | 0.00 | 0.00 | 112.46 |
| Arthur, Regina, A,19089 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Goel, April, C,16166 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Lin, Laura, L,11462 | 8116.33 | 0.00 | 3374.99 | 0.00 | 4741.34 |
| Martinez, Monica, A,14129 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Ortega, Janet, L,11754 | 8163.53 | 0.00 | 3399.99 | 0.00 | 4763.54 |
| Zeng, Marshall, M,20987 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Guo, Ernest,25717 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Powell, Grace, B,29194 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Pal, Christy, R,18739 | 5371.74 | 0.00 | 3578.27 | 0.00 | 1793.47 |
| Martin, Randall, B,19560 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Sun, Krystal,18908 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Garcia, Donald,18929 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Ortega, Linda, C,11756 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Kumar, Kenneth,11472 | 8165.82 | 0.00 | 3399.99 | 0.00 | 4765.83 |
| Sun, Candice, A,19568 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Gill, Melinda, G,11151 | 8087.31 | 0.00 | 3374.99 | 0.00 | 4712.32 |
| Navarro, Kathleen, J,19269 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Navarro, Marc,16346 | 37.55 | 0.00 | 0.00 | 0.00 | 37.55 |
| Subram, Troy, R,19607 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| She, Latoya, A,11750 | 8148.02 | 0.00 | 3399.99 | 0.00 | 4748.03 |
| Liu, Suzanne,19594 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Stone, Colin, K,12673 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
| Liu, Alejandro, R,19555 | 6110.60 | 0.00 | 3578.27 | 0.00 | 2532.33 |
| Yang, Shannon,12001 | 8113.01 | 0.00 | 3374.99 | 0.00 | 4738.02 |
| Xie, Jaime,25823 | 1887.56 | 0.00 | 699.10 | 0.00 | 1188.46 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Ye, Claudia, J,19102 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Jimenez, Julio,24005 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Martinez, Terrance,25718 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Lee, Destiny,17058 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Gutierrez, Lawrence, M,19564 | 5293.24 | 0.00 | 3578.27 | 0.00 | 1714.97 |
| Saunders, Jillian,21178 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Lu, Roger, F,19763 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Ashe, Orlando, I,11897 | 8203.02 | 0.00 | 3399.99 | 0.00 | 4803.03 |
| Garcia, Virginia, C,24599 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Jai, Tasha, A,19771 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Luo, Christine, J,24159 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Watson, Nathaniel, H,25826 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Wang, Rosa, I,11993 | 8131.32 | 0.00 | 3374.99 | 0.00 | 4756.33 |
| Torres, Marc,11765 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Alvarez, Linda,14047 | 5643.54 | 0.00 | 0.00 | 3321.26 | 2322.28 |
| Munoz, Gloria, L,19789 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Guo, Trisha,18253 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Barnes, Mariah, H,19621 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Yuan, Carl, P,24160 | 3046.84 | 0.00 | 0.00 | 2443.35 | 603.49 |
| Garcia, Sarah,11907 | 8135.33 | 0.00 | 3399.99 | 0.00 | 4735.34 |
| Subram, Candace,27585 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Garcia, George,20160 | 4237.22 | 0.00 | 3578.27 | 0.00 | 658.95 |
| Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
| Blanco, Rodney, A,20158 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Gill, Byron, J,18483 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Lopez, Kristina, L,20247 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Weber, Levi, A,13120 | 205.39 | 0.00 | 0.00 | 0.00 | 205.39 |
| Ms., Robinson, Dorothy, B.,11952 | 8169.00 | 0.00 | 3374.99 | 0.00 | 4794.01 |
| Weber, Jarrod, M,14859 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Zheng, Jaclyn, F,11910 | 8113.03 | 0.00 | 3374.99 | 0.00 | 4738.04 |
| Lopez, Carla, G,28326 | 2442.54 | 0.00 | 0.00 | 0.00 | 2442.54 |
| She, Rafael, I,20152 | 4142.75 | 0.00 | 3578.27 | 564.48 | 0.00 |
| Simpson, Tara, K,28107 | 810.32 | 0.00 | 0.00 | 0.00 | 810.32 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
Generated 2025-12-21 19:49:42.348 UTC