[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 909 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| She, Maurice,22917 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alonso, Kristine,16686 | 4157.73 | 3578.27 | 0.00 | 0.00 | 579.46 |
| Lal, Mitchell, C,20403 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gomez, Derrick,18694 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Torres, Sabrina, E,20425 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Perez, Ebony, M,24900 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Rai, Raul, R,15133 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Hernandez, Ross,14677 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Suri, Molly,17503 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Gonzalez, Brandy,27368 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Diaz, Gary,27482 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2049.10 | 1581.83 |
| Black, Mindy, W,18696 | 6149.57 | 0.00 | 3578.27 | 0.00 | 2571.30 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 0.00 | 60.05 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 0.00 | 100.25 |
| Shen, Bridget,17237 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Zhao, Glenn, C,14221 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 0.00 | 928.49 |
| Collins, Logan, H,13983 | 180.41 | 0.00 | 0.00 | 0.00 | 180.41 |
| Ye, Gilbert,29344 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Chander, Tonya,15794 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Mehta, Pamela,22005 | 135.46 | 0.00 | 0.00 | 0.00 | 135.46 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Zheng, Jenny, R,11947 | 4747.30 | 0.00 | 3374.99 | 629.96 | 742.35 |
| Ruiz, Alfredo,21975 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Zhang, Alejandro, P,21992 | 184.26 | 0.00 | 0.00 | 0.00 | 184.26 |
| Fernandez, Emmanuel,28955 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Kumar, Alejandro,14055 | 5177.40 | 0.00 | 0.00 | 2049.10 | 3128.30 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Nelson, Kaitlyn, J,24276 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Ruiz, Shannon,20822 | 4134.53 | 0.00 | 3578.27 | 0.00 | 556.26 |
| Perez, Johnathan, D,20426 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Parker, Evan, R,18729 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Yang, Warren, F,17908 | 35.72 | 0.00 | 0.00 | 0.00 | 35.72 |
| Rogers, Seth, R,14318 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Chande, Latoya, M,23309 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ramos, Audrey,11976 | 8087.31 | 0.00 | 3374.99 | 0.00 | 4712.32 |
| Gill, Eddie, J,12715 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Liu, Clayton, L,21373 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Clark, Sydney,16610 | 67.58 | 0.00 | 0.00 | 0.00 | 67.58 |
| Mehta, Edgar,11761 | 8149.49 | 0.00 | 3399.99 | 0.00 | 4749.50 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 0.00 | 3399.99 | 0.00 | 4737.01 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Sai, Cassandra, R,28110 | 845.31 | 0.00 | 0.00 | 0.00 | 845.31 |
| Guo, Clarence,20265 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Chandra, Dominique, H,26765 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Perez, Dominique,12344 | 68.70 | 0.00 | 0.00 | 0.00 | 68.70 |
| Diaz, Kellie, A,18330 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| Ma, Rafael, T,13022 | 2644.02 | 0.00 | 0.00 | 2049.10 | 594.92 |
| Hernandez, Armando,21950 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Sara, Cesar, C,22172 | 2932.30 | 0.00 | 0.00 | 2181.56 | 750.74 |
| Andersen, Tonya, N,13527 | 4529.04 | 0.00 | 0.00 | 2049.10 | 2479.94 |
| Torres, Jacqueline,21976 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Raji, Katrina, M,16517 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Liang, Glenn,21983 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
Generated 2025-12-24 06:07:03.096 UTC