[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 969 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Johnsen, Eddie,28935 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Xu, Kara, E,22212 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Chander, Roger,25214 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Goel, Lacey, N,18704 | 33.26 | 0.00 | 0.00 | 0.00 | 33.26 |
| Anand, Cassie, M,29342 | 801.83 | 0.00 | 0.00 | 0.00 | 801.83 |
| Serrano, Alberto, L,15800 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Sanz, Linda, P,22945 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Sharma, Keith,15728 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Martin, Natasha, N,27490 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Diaz, Danny, C,18190 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Fernandez, Cassandra, C,14134 | 3835.07 | 0.00 | 0.00 | 2049.10 | 1785.97 |
| Zhao, Heather,24596 | 4168.83 | 0.00 | 0.00 | 2443.35 | 1725.48 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 0.00 | 2478.34 |
| Ye, Vincent,13013 | 256.24 | 0.00 | 0.00 | 0.00 | 256.24 |
| He, Omar,15831 | 2646.36 | 0.00 | 0.00 | 2049.10 | 597.26 |
| Liu, Susan,18718 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
| Chande, Willie, B,16163 | 2641.39 | 0.00 | 0.00 | 2071.42 | 569.97 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 0.00 | 61.58 |
| Serrano, Hector, K,28308 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Guo, Louis, D,15764 | 4413.39 | 0.00 | 0.00 | 2071.42 | 2341.97 |
| Goel, Alicia, H,20423 | 4177.74 | 0.00 | 3578.27 | 0.00 | 599.47 |
| Allen, Logan,15812 | 81.25 | 0.00 | 0.00 | 0.00 | 81.25 |
| Vazquez, Anne,16027 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Nath, Dawn, L,11759 | 8054.05 | 0.00 | 3374.99 | 0.00 | 4679.06 |
| Rodriguez, Cynthia, E,22206 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Ramos, Leslie,15733 | 4443.55 | 0.00 | 0.00 | 2049.10 | 2394.45 |
| Ye, Amy,11073 | 191.90 | 0.00 | 0.00 | 0.00 | 191.90 |
| Rana, Stanley, J,22919 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Muñoz, Jaime, C,24506 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Arun, Levi, A,11074 | 94.19 | 0.00 | 0.00 | 0.00 | 94.19 |
| Prasad, Brandy, P,14009 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Zhang, Kristen,27484 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 0.00 | 2443.35 | 1798.96 |
| Zheng, Erica, K,23643 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xu, Colin,15790 | 2668.38 | 0.00 | 0.00 | 2071.42 | 596.96 |
| Navarro, Latasha, L,11100 | 8172.51 | 0.00 | 3374.99 | 0.00 | 4797.52 |
| Vance, George, R,12038 | 66.76 | 0.00 | 0.00 | 0.00 | 66.76 |
| Deng, Jodi,16161 | 2700.05 | 0.00 | 0.00 | 2049.10 | 650.95 |
| Lal, Tracy, W,23086 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Dominguez, Leslie,27346 | 1390.95 | 0.00 | 0.00 | 782.99 | 607.96 |
| Ma, Laura, L,24503 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Chande, Carl,18932 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Gonzalez, Savannah, F,15644 | 3803.68 | 0.00 | 0.00 | 2071.42 | 1732.26 |
| Ramos, Roy, A,24482 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Hernandez, Darren, A,18709 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Beck, Cedric, L,22403 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Alonso, Naomi,15830 | 2680.38 | 0.00 | 0.00 | 2071.42 | 608.96 |
| Serrano, Dana, S,12678 | 341.43 | 0.00 | 0.00 | 0.00 | 341.43 |
| Perez, Dominique,12344 | 68.70 | 0.00 | 0.00 | 0.00 | 68.70 |
| Xu, Kristen,15751 | 4446.40 | 0.00 | 0.00 | 2071.42 | 2374.98 |
| Goel, Alisha, C,26767 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Romero, Diane, F,21947 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Kumar, Robert,25226 | 2158.90 | 0.00 | 0.00 | 1000.44 | 1158.46 |
| Diaz, Aaron, C,18695 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Nara, Melvin, E,27147 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Blanco, Jimmy, V,14013 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Gill, Mathew, M,27486 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
Generated 2025-12-23 07:27:33.261 UTC