[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 4739.30 | 0.00 |
| Raji, Misty,16520 | 4727.74 | 3578.27 | 0.00 | 1149.47 | 0.00 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 4714.05 | 0.00 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 1183.47 | 0.00 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Huang, Damien,16524 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Zhang, Warren, L,25252 | 1893.05 | 699.10 | 0.00 | 0.00 | 1193.95 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 2408.97 | 756.33 |
| Ramos, Francis,16345 | 4173.24 | 3578.27 | 0.00 | 0.00 | 594.97 |
| She, Tonya, L,16521 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 2399.47 | 776.33 |
| Chander, Yolanda,16519 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Sutton, Jaime, L,16630 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 344.04 | 0.00 |
| Yang, Todd, J,19094 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Sanchez, Terrance,19584 | 116.74 | 0.00 | 0.00 | 116.74 | 0.00 |
| Wu, Kelvin,24595 | 61.96 | 0.00 | 0.00 | 61.96 | 0.00 |
| Gray, Faith,22914 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2894.56 | 742.35 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 2309.97 | 2384.07 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Gao, Stacey,16662 | 4355.71 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
Generated 2024-09-19 23:54:56.936 UTC