[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1031 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 0.00 | 1000.44 | 1179.47 |
| Alonso, Diane, M,20630 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Gonzales, Hunter,26570 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Kumar, Keith, M,25224 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jimenez, Joy,28312 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Raji, Devon, D,21898 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 0.00 | 32.96 |
| Zhao, Kristen,16930 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Lin, Jaclyn,28721 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Mallory, V,17289 | 106.95 | 0.00 | 0.00 | 0.00 | 106.95 |
| Raman, Ruben,15580 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 2318.96 | 2420.34 |
| Morris, Isaac, G,26439 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Chandra, Cynthia,22000 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Ms., Seidel, Birgit,16621 | 73.86 | 0.00 | 0.00 | 0.00 | 73.86 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Liang, Lacey, A,15719 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Alonso, Krista, P,20212 | 100.74 | 0.00 | 0.00 | 0.00 | 100.74 |
| Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Ruiz, Julio,11005 | 8121.33 | 3374.99 | 0.00 | 2362.27 | 2384.07 |
| Taylor, Ashley, E,18215 | 150.97 | 0.00 | 0.00 | 0.00 | 150.97 |
| Van, Cassandra,13525 | 4607.23 | 0.00 | 0.00 | 2071.42 | 2535.81 |
| He, Ramon,26919 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Jai, Warren, S,16483 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Navarro, Leslie, E,24371 | 4193.82 | 0.00 | 0.00 | 2443.35 | 1750.47 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 0.00 | 2049.10 | 4713.05 |
| Raje, Darrell,20252 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sharma, Terrence, N,17351 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Wu, Bianca, F,28485 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Cai, Warren,24918 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Zeng, Krystal, A,25814 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Zheng, Aimee, H,24283 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Perez, Marie,13996 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Sara, Ann, A,23576 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sara, George,24247 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Arthur, Jay, R,12694 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Andersen, Carl, J,11057 | 8088.04 | 0.00 | 3374.99 | 2319.99 | 2393.06 |
| Gonzalez, Marco,27598 | 556.26 | 0.00 | 0.00 | 0.00 | 556.26 |
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Anand, Rafael,29306 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Barnes, Taylor,14279 | 5137.71 | 0.00 | 0.00 | 2049.10 | 3088.61 |
| Jai, Rafael, L,17323 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 0.00 | 4812.51 |
| Ortega, Renee,18447 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lal, Shaun, H,17056 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Hu, Jenny, A,16634 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Nara, Dawn, M,21891 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Gutierrez, Armando,29310 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Pais, Wilson, C,13038 | 5581.26 | 0.00 | 0.00 | 2071.42 | 3509.84 |
| Liang, Martha,16525 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Chande, Michele, C,13078 | 6850.46 | 0.00 | 0.00 | 2071.42 | 4779.04 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Fernandez, Ivan,22032 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Liu, Clarence,19797 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Andersen, Tonya, N,13527 | 4529.04 | 0.00 | 0.00 | 2049.10 | 2479.94 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Bhat, Edwin,13079 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Wu, Amy,19790 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
Generated 2025-12-22 02:29:50.265 UTC