[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Turner, Savannah, E,23430 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yang, Hunter, E,20237 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2049.10 | 1587.81 |
| Ramos, Adrienne, L,28216 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rodriguez, Geoffrey,20817 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Chander, Alison,18249 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Malhotra, Emmanuel,18332 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Raje, Colleen, M,19084 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Fernandez, Ivan,22032 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Rubio, Nelson,26433 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Weber, Chelsea,29191 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Pal, Sheena, D,21197 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Chande, Carl,18932 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Alonso, Kathleen,21196 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Raman, Candace, M,11766 | 8280.48 | 0.00 | 3399.99 | 0.00 | 4880.49 |
| Alvarez, Beth, M,29305 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Martin, Byron, E,25217 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gomez, Adrienne,11920 | 8156.32 | 0.00 | 3374.99 | 0.00 | 4781.33 |
| Vazquez, Theresa, F,22581 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Ramos, Rebekah, L,27984 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Xu, Tracy, L,17916 | 4787.74 | 0.00 | 3578.27 | 0.00 | 1209.47 |
| Zhou, Steve, C,20263 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Raji, Shawna, P,13961 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Xu, Kelsey, W,28220 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Long, Megan, J,15791 | 42.26 | 0.00 | 0.00 | 0.00 | 42.26 |
| Beck, Ashlee, L,26666 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Cai, Alvin, D,11115 | 35.23 | 0.00 | 0.00 | 0.00 | 35.23 |
| Navarro, Jaime, T,27690 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Fernandez, Denise, A,18724 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Dominguez, Philip,15730 | 122.96 | 0.00 | 0.00 | 0.00 | 122.96 |
| Vazquez, Ross,11148 | 126.24 | 0.00 | 0.00 | 0.00 | 126.24 |
| Beck, Derek,17322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Chandra, Gerald,25131 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Madan, Cory,26154 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Zimmerman, Krystal,17228 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Lopez, Darren,29081 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Zeng, Jon, O,14310 | 5200.66 | 0.00 | 0.00 | 2071.42 | 3129.24 |
| Guo, Sandra,23664 | 3941.53 | 0.00 | 0.00 | 2181.56 | 1759.97 |
| Patel, Harold,24585 | 3366.02 | 0.00 | 0.00 | 2181.56 | 1184.46 |
| Dominguez, Joy,22175 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Taylor, Logan,13522 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 2294.99 | 2419.06 |
| Alonso, Gloria, S,19964 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Ashe, Katie, Z,26770 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Arun, Gerald,25940 | 1277.56 | 0.00 | 699.10 | 0.00 | 578.46 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
| Mr., Spencer, Phil,19960 | 6120.11 | 0.00 | 3578.27 | 0.00 | 2541.84 |
| Shan, Elijah, L,26795 | 1992.46 | 0.00 | 0.00 | 782.99 | 1209.47 |
| Hernandez, Joe,15154 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Blanco, Jésus, E,20448 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Jai, Latoya, S,21229 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Suri, Lydia,13126 | 6815.08 | 0.00 | 0.00 | 2049.10 | 4765.98 |
| Madan, Joe,29300 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Rai, Calvin,15229 | 2833.57 | 0.00 | 0.00 | 2049.10 | 784.47 |
| Moreno, Roy, J,19951 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Martinez, Meredith, M,19095 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Subram, Ann, M,18693 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
Generated 2025-12-21 16:04:18.615 UTC