[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 23 < SKIP 313 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Goel, Drew,17352 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Raji, Tasha, T,17057 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Luo, Michele,26027 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Andersen, Jodi,26766 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gao, Erica, R,19087 | 47.20 | 0.00 | 0.00 | 36.96 | 10.24 |
| Sanz, Theodore, M,16492 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
| Rivera, Evan, Y,26757 | 1344.47 | 0.00 | 0.00 | 782.99 | 561.48 |
| Liang, Vincent,20402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chen, Tiffany, A,23348 | 4167.31 | 0.00 | 0.00 | 2443.35 | 1723.96 |
| Anand, Carly,25918 | 1260.58 | 0.00 | 699.10 | 0.00 | 561.48 |
| Serrano, Dwayne,16695 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Lal, Clarence, L,24470 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ward, Jessica,15587 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| She, Jerry, C,14277 | 5196.74 | 0.00 | 0.00 | 2071.42 | 3125.32 |
| Torres, Mathew, L,18900 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Mr., Schmidt, Steve,15789 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Watson, Maria,17229 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Xie, Brendan,13018 | 2642.38 | 0.00 | 0.00 | 2071.42 | 570.96 |
| Zhang, Amy,18307 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Thompson, Justin,22954 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Goel, Roger, A,23652 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Torres, Jacqueline,21976 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Mehta, Heidi,14226 | 5656.24 | 0.00 | 0.00 | 2071.42 | 3584.82 |
| Yang, Tiffany, K,21215 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Mehta, Nancy,18189 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Sun, Dennis, K,24481 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Harris, Eduardo, S,18238 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Liu, Bianca, K,11458 | 31.92 | 0.00 | 0.00 | 0.00 | 31.92 |
| Garcia, Tina,17231 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Shen, Tamara, G,22935 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Ramos, Carolyn,17926 | 4715.70 | 0.00 | 3578.27 | 0.00 | 1137.43 |
| Raman, Michele,17233 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Navarro, Francis, J,27520 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Chande, Michele, C,13078 | 6850.46 | 0.00 | 0.00 | 2071.42 | 4779.04 |
| Goldberg, Mindy,16159 | 4411.65 | 0.00 | 0.00 | 2071.42 | 2340.23 |
| Chander, Alisha,12572 | 2611.41 | 0.00 | 2071.42 | 0.00 | 539.99 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Green, Jonathan, A,17332 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Tang, Julie,26589 | 1966.46 | 0.00 | 0.00 | 782.99 | 1183.47 |
| Jimenez, Neil,22151 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Lewis, Nicole,21881 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Gao, Randy,25113 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Andersen, Tonya, N,13527 | 4529.04 | 0.00 | 0.00 | 2049.10 | 2479.94 |
| Russell, Seth,25138 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Wang, Crystal, C,11112 | 8295.02 | 0.00 | 3374.99 | 0.00 | 4920.03 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Shen, Jodi, A,22028 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Li, David, A,21894 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Martin, Casey, J,22962 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Huang, Vincent, A,18703 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Gonzalez, Dominique, J,27976 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Gonzalez, Tina,19653 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Jackson, Joshua,17235 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Patel, Harold,24585 | 3366.02 | 0.00 | 0.00 | 2181.56 | 1184.46 |
| Jai, Nichole, R,28348 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Chande, Arturo, H,14860 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Hernandez, Erik, C,21998 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Prasad, Meagan,19611 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Sanchez, Ross,28310 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-24 06:17:53.542 UTC