[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 31 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| He, Jessie,29094 | 796.34 | 0.00 | 0.00 | 0.00 | 796.34 |
| Lee, Richard, I,23996 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 2071.42 | 0.00 | 4734.05 |
| Ashe, Misty, R,23129 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Fernandez, Carolyn, S,29302 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 8.99 | 64.97 |
| Guo, Autumn, A,14213 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Vazquez, Ruben, B,14301 | 5142.75 | 0.00 | 0.00 | 2071.42 | 3071.33 |
| Mehta, Heidi,14226 | 5656.24 | 0.00 | 0.00 | 2071.42 | 3584.82 |
| Ramirez, Mason, K,25107 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Murphy, Grace, J,23655 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Martin, Joe,14668 | 5216.69 | 0.00 | 0.00 | 2071.42 | 3145.27 |
| Deng, Peter, A,24006 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Shen, Cristina,26768 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Liu, Warren,15014 | 3860.87 | 0.00 | 0.00 | 2071.42 | 1789.45 |
| Carson, Bradley,23995 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Goel, Alisha, C,26767 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2049.10 | 3092.33 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2888.58 | 742.35 |
| Gao, Micah, W,25106 | 2170.92 | 0.00 | 0.00 | 1000.44 | 1170.48 |
| Zimmerman, Candice, J,26754 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Rivera, Evan, Y,26757 | 1344.47 | 0.00 | 0.00 | 1344.47 | 0.00 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Shen, Brendan, L,14305 | 3652.20 | 0.00 | 0.00 | 2049.10 | 1603.10 |
| Arun, Ross, C,23658 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Goel, Tara, I,14347 | 2900.39 | 0.00 | 0.00 | 2071.42 | 828.97 |
| Alvarez, Randall,26750 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Alvarez, Larry, T,14235 | 5682.20 | 0.00 | 0.00 | 2071.42 | 3610.78 |
| Ramos, Naomi, M,23656 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Zhang, Damien, C,26758 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
Generated 2025-11-06 14:34:25.432 UTC