[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 906 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Serrano, Pedro,26189 | 1926.45 | 0.00 | 0.00 | 782.99 | 1143.46 |
| Long, Alexis,22580 | 3051.31 | 0.00 | 0.00 | 2443.35 | 607.96 |
| Sanchez, Nancy, L,22207 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Mehta, Denise,13080 | 6844.41 | 0.00 | 0.00 | 2049.10 | 4795.31 |
| Carlson, Briana,26436 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Madan, Evelyn, D,22582 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Vazquez, Armando,22571 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
| Romero, Julio,22857 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Rubio, Nelson,26433 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| She, Kathryn, I,26443 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Suri, Pedro,26422 | 1980.96 | 0.00 | 0.00 | 782.99 | 1197.97 |
| He, Amy,22411 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Kumar, Cedric, B,22860 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Shen, Kelvin,22406 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Guo, Jon,22927 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Jai, Maurice,22932 | 4169.33 | 0.00 | 0.00 | 4169.33 | 0.00 |
| Xu, Alejandro, R,26585 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Shan, Bridget,29338 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Moreno, Leslie, C,11114 | 122.89 | 0.00 | 0.00 | 0.00 | 122.89 |
| Lopez, Darren,29081 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Madan, Geoffrey, M,15241 | 51.91 | 0.00 | 0.00 | 0.00 | 51.91 |
| Goel, Karl,18705 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Liu, Bianca, K,11458 | 31.92 | 0.00 | 0.00 | 0.00 | 31.92 |
| Nara, Yolanda,29080 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Ortega, Felicia, J,11753 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| She, Nina,22961 | 3891.54 | 0.00 | 0.00 | 2181.56 | 1709.98 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 0.00 | 1000.44 | 1179.47 |
| Johnsen, Mario, W,26587 | 1920.42 | 0.00 | 0.00 | 782.99 | 1137.43 |
| Cai, Amy,24920 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Rai, Johnny, A,13135 | 6773.14 | 0.00 | 0.00 | 2049.10 | 4724.04 |
| Chen, Crystal, M,26566 | 2016.95 | 0.00 | 0.00 | 782.99 | 1233.96 |
| Ortega, Eddie,22908 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Gao, Bianca, C,13112 | 5717.89 | 0.00 | 0.00 | 2049.10 | 3668.79 |
| Johnson, Logan, K,22931 | 3882.55 | 0.00 | 0.00 | 3882.55 | 0.00 |
| Raji, Kelli, G,13123 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
| Kennedy, Devon, J,13133 | 6813.12 | 0.00 | 0.00 | 2049.10 | 4764.02 |
| Yuan, Kathryn, L,23106 | 3956.01 | 0.00 | 0.00 | 2181.56 | 1774.45 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Goldstein, Brendan,13518 | 2638.36 | 0.00 | 0.00 | 2049.10 | 589.26 |
| Sharma, Lindsay, E,24478 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Deng, Jodi,16161 | 2700.05 | 0.00 | 0.00 | 2049.10 | 650.95 |
| Xu, Willie, C,13160 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Zeng, Tiffany, B,21890 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Martinez, Heidi, L,22922 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Yuan, Willie,23421 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Navarro, Cheryl,13109 | 5682.90 | 0.00 | 0.00 | 2049.10 | 3633.80 |
| Pal, Kara,24916 | 2169.90 | 0.00 | 0.00 | 1000.44 | 1169.46 |
| Blanco, Hector, J,22938 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Suarez, Casey,26548 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 0.00 | 2071.42 | 4793.53 |
| Chande, Kelli, C,22933 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 0.00 | 4492.45 | 0.00 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 0.00 | 3490.03 | 0.00 |
| Kumar, Michele,23107 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Tang, Latoya, F,22910 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Garcia, Martin, l,23332 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Sara, Ebony,24923 | 2159.40 | 0.00 | 0.00 | 1000.44 | 1158.96 |
| Wu, Brittney,23418 | 3400.02 | 0.00 | 0.00 | 2181.56 | 1218.46 |
| Moreno, Monique, R,23118 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
Generated 2026-01-04 05:25:02.795 UTC