[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 999 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ye, Erica, E,13010 | 5716.52 | 0.00 | 0.00 | 2071.42 | 3645.10 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 0.00 | 2071.42 | 4789.02 |
| Serrano, Pedro,26189 | 1926.45 | 0.00 | 0.00 | 782.99 | 1143.46 |
| Martin, Ruben,22400 | 2737.82 | 0.00 | 0.00 | 2181.56 | 556.26 |
| Zhu, Erica,25221 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Butler, Elijah, D,21551 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Vazquez, Mallory, M,18283 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Martin, Gerald, K,17284 | 90.25 | 0.00 | 0.00 | 31.27 | 58.98 |
| Li, Gilbert,23999 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Kumar, Warren, A,24003 | 2806.53 | 0.00 | 0.00 | 2181.56 | 624.97 |
| Gill, Jimmy,29098 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Sanchez, Nancy, L,22207 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| 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 |
| Vazquez, Juan, P,22578 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Shen, Alisha, J,26438 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| He, Amy,22411 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Goel, Yolanda, M,26435 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Xu, Alejandro, R,26585 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Suri, Jillian, L,15180 | 4466.39 | 0.00 | 0.00 | 2071.42 | 2394.97 |
| Zhou, Krystal,23593 | 3990.01 | 0.00 | 0.00 | 2181.56 | 1808.45 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Srini, Douglas, M,16733 | 35.26 | 0.00 | 0.00 | 0.00 | 35.26 |
| Liang, Barbara, T,22953 | 3899.49 | 0.00 | 0.00 | 2181.56 | 1717.93 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Nelson, Mary, L,13107 | 5650.90 | 0.00 | 0.00 | 2049.10 | 3601.80 |
| She, Nina,22961 | 3891.54 | 0.00 | 0.00 | 2181.56 | 1709.98 |
| Russell, Noah, M,26447 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Ortega, Eddie,22908 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Diaz, Jill, F,22936 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Wilson, Edward, L,26562 | 1925.41 | 0.00 | 0.00 | 782.99 | 1142.42 |
| Raji, Kelli, G,13123 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
| Shan, Carl, D,24919 | 2212.89 | 0.00 | 0.00 | 1000.44 | 1212.45 |
| Nelson, Carol,13520 | 4551.36 | 0.00 | 0.00 | 2071.42 | 2479.94 |
| Lal, Bradley,13156 | 2663.69 | 0.00 | 0.00 | 2071.42 | 592.27 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Tang, Latoya, F,22910 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Sara, Ebony,24923 | 2159.40 | 0.00 | 0.00 | 1000.44 | 1158.96 |
| Perez, Ivan, S,23408 | 4218.82 | 0.00 | 0.00 | 2443.35 | 1775.47 |
| Browning, Javier,23120 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Ramos, Danny,23121 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Moreno, Monique, R,23118 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Kapoor, Cesar, J,24302 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Guo, Sandra,23664 | 3941.53 | 0.00 | 0.00 | 2181.56 | 1759.97 |
| Alvarez, Kristy,15588 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Hernandez, Mallory,29091 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Garcia, Monica, D,20267 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Griffin, Noah, E,29118 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Gill, Gary, B,25108 | 2199.41 | 0.00 | 0.00 | 1000.44 | 1198.97 |
| Anderson, Richard, G,24924 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Raman, Jay, M,13618 | 6763.15 | 0.00 | 0.00 | 2049.10 | 4714.05 |
| Kumar, Lacey,13960 | 6871.74 | 0.00 | 0.00 | 2071.42 | 4800.32 |
| Allen, Kaylee,26653 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Munoz, Meredith,13957 | 5645.24 | 0.00 | 0.00 | 2071.42 | 3573.82 |
| Chen, Aimee,26591 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Chen, Tiffany, A,23348 | 4167.31 | 0.00 | 0.00 | 2443.35 | 1723.96 |
| Sutton, Kern, A,26660 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Gray, Jeremiah,23331 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
Generated 2025-12-23 05:00:23.007 UTC