[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Johnsen, Willie,15218 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Hall, Haley,27489 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Prasad, Meagan,19611 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Torres, Sabrina, E,20425 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Srini, Jay, M,18326 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Becker, Gregory, M,13104 | 6894.44 | 0.00 | 0.00 | 2071.42 | 4823.02 |
| Simmons, Jacqueline, W,13137 | 177.94 | 0.00 | 0.00 | 0.00 | 177.94 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Torres, Walter,26784 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Suri, Douglas,19096 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Prasad, George, C,15767 | 4379.09 | 0.00 | 0.00 | 2049.10 | 2329.99 |
| Yuan, Willie,23421 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Zhu, Colleen,17252 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Ms., Sandidge, Mary, R.,14016 | 121.06 | 0.00 | 0.00 | 0.00 | 121.06 |
| Sun, Lacey, L,15131 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Navarro, Cheryl,13109 | 5682.90 | 0.00 | 0.00 | 2049.10 | 3633.80 |
| Shan, Derek, R,19782 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Ma, Cara,18885 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Lopez, Luis, P,17334 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Rubio, Derrick, P,23525 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Cook, Victoria, J,20620 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Anand, Ricardo,21383 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Wu, Warren, M,15602 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 0.00 | 4492.45 | 0.00 |
| Jai, Katrina,13044 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Arun, Denise,28218 | 18.97 | 0.00 | 0.00 | 0.00 | 18.97 |
| Zhou, Laura, D,12683 | 6801.45 | 0.00 | 0.00 | 2071.42 | 4730.03 |
| Vance, Phillip,29308 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Luo, Lacey,24175 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Xie, Kelli, J,20452 | 6156.70 | 0.00 | 3578.27 | 0.00 | 2578.43 |
| Pal, Roger, D,27705 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raji, Jaclyn,18289 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 0.00 | 2443.35 | 1725.98 |
| Yuan, Jon,25937 | 1299.56 | 0.00 | 699.10 | 0.00 | 600.46 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 0.00 | 2181.56 | 1209.47 |
| Garcia, Chelsea,21961 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Allen, Kaylee,26653 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Sun, Edwin, O,21170 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Sanders, Charles, E,21967 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Serrano, Jacquelyn,21963 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Adams, Savannah,23536 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| She, Stacey,26748 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Diaz, Rebekah, J,21378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Liang, Randy, E,28958 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Ortega, Eddie,22908 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Saunders, Brandy,11946 | 4697.31 | 0.00 | 3399.99 | 0.00 | 1297.32 |
| Chande, Jaclyn, S,18698 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Mr., Solanki, Ajay,18295 | 144.27 | 0.00 | 0.00 | 0.00 | 144.27 |
| Gutierrez, Joy, A,18466 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Malhotra, Douglas, L,22960 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gill, Mallory, P,16698 | 197.88 | 0.00 | 0.00 | 0.00 | 197.88 |
| Madan, Jay, L,20156 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| She, Nichole, M,11909 | 8105.31 | 0.00 | 3374.99 | 0.00 | 4730.32 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Sharma, Christian,15809 | 62.59 | 0.00 | 0.00 | 0.00 | 62.59 |
Generated 2025-12-21 15:35:03.647 UTC