[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 53 > < TAKE 48 >
48 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Scott, Savannah, E,16929 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Lopez, Edgar, O,17346 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Yuan, Bradley,17920 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 0.00 | 115.93 |
| Deng, Kurt, D,13635 | 215.74 | 0.00 | 0.00 | 32.27 | 183.47 |
| Simmons, Isabel, H,26432 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 0.00 | 2049.10 | 4742.00 |
| Suri, Marie,24281 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Sanz, Marvin,19612 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Li, Kristen, R,15153 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Liang, Brittney, R,26182 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Suarez, Lance, C,17230 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Gonzalez, Summer, L,20266 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Yang, Tiffany, K,21215 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Hernandez, Joe,15154 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Yuan, Derek, L,27589 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Kumar, Chad,11095 | 8158.01 | 0.00 | 3374.99 | 2363.96 | 2419.06 |
| Rubio, Randall, M,17286 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Madan, Roy,15716 | 4467.06 | 0.00 | 0.00 | 2049.10 | 2417.96 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Madan, Michele, A,12676 | 6859.46 | 0.00 | 0.00 | 2071.42 | 4788.04 |
| Alvarez, Diana,13638 | 6832.12 | 0.00 | 0.00 | 2049.10 | 4783.02 |
| Gao, Amy,21996 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Luo, Dustin,17240 | 4385.03 | 0.00 | 3578.27 | 0.00 | 806.76 |
| Perez, Patricia,25022 | 1564.92 | 0.00 | 0.00 | 1000.44 | 564.48 |
| Ruiz, Krista, C,13081 | 6772.15 | 0.00 | 0.00 | 2049.10 | 4723.05 |
| Navarro, Daisy,27514 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Green, Jonathan, A,17332 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Smith, Allen,14072 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Blanco, Leslie, L,27695 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Chow, Christy, M,12681 | 6784.13 | 0.00 | 0.00 | 2049.10 | 4735.03 |
| Navarro, Lori,21182 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Lal, Mario, T,23345 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Goel, Bradley,15803 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Madan, Raymond, W,20819 | 4181.76 | 0.00 | 3578.27 | 0.00 | 603.49 |
| Butler, Katherine, F,26760 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Ramos, Kendra,24896 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 0.00 | 2049.10 | 4713.05 |
| Suarez, Rebekah,13649 | 6812.13 | 0.00 | 0.00 | 2049.10 | 4763.03 |
| Rubio, Jay,15179 | 4444.89 | 0.00 | 0.00 | 2071.42 | 2373.47 |
| Luo, Nina,27495 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Flores, Connor,15755 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Goel, Alejandro, K,13077 | 6766.63 | 0.00 | 0.00 | 2049.10 | 4717.53 |
| Martinez, Harold, J,20604 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
Generated 2025-12-24 06:00:36.096 UTC