[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 60 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chen, Jaclyn, C,22847 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Navarro, Rodney, L,29309 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Simmons, Jacqueline, W,13137 | 177.94 | 0.00 | 0.00 | 0.00 | 177.94 |
| Rana, Terrance, M,28134 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Rubio, Juan,16170 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Vance, Ruth, D,17302 | 147.44 | 0.00 | 0.00 | 0.00 | 147.44 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Ma, Cara,18885 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Andersen, Jaime,25268 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Nara, Melvin, E,27147 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Madan, Jay, L,20156 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Patterson, Jennifer, M,15129 | 5177.73 | 0.00 | 0.00 | 2071.42 | 3106.31 |
| Powell, Aaron,25241 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Garcia, Donald,18929 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Peterson, Allison, A,26421 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Gonzalez, Roy, M,13040 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Wang, Arturo, A,27720 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Russell, Alexis, L,13634 | 234.93 | 0.00 | 0.00 | 0.00 | 234.93 |
| Gray, Stephanie,17064 | 4506.76 | 0.00 | 3578.27 | 0.00 | 928.49 |
| Hu, Stacey,12696 | 159.00 | 0.00 | 0.00 | 0.00 | 159.00 |
| Serrano, Diane, E,14857 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Fernandez, Shane, A,13127 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Navarro, Jonathon,18722 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Srini, Manuel,24168 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Andersen, Maurice,15206 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Johnsen, Eddie,28935 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Navarro, Kathleen, J,19269 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
Generated 2025-12-21 13:50:59.184 UTC