[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1434 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gutierrez, Marvin,25938 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Chande, Tonya,11992 | 8123.03 | 0.00 | 3399.99 | 0.00 | 4723.04 |
| Munoz, Latasha,11967 | 8153.02 | 0.00 | 3374.99 | 0.00 | 4778.03 |
| Ward, Katelyn,20258 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Martin, Anna, L,20988 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Arthur, Raymond, S,20228 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Raman, Summer, C,25949 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Lu, Jeffery, B,19971 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Collins, Andrea,12250 | 3964.98 | 0.00 | 3399.99 | 0.00 | 564.99 |
| Goel, Jodi,20447 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Morcos, Hany,20821 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Perez, Johnathan, D,20426 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Hu, Cara,20608 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Sara, Cassandra, D,20989 | 4148.74 | 0.00 | 3578.27 | 0.00 | 570.47 |
| Zhou, Jessie,20610 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Shan, Deborah,20624 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Tang, April, A,25935 | 1256.03 | 0.00 | 699.10 | 0.00 | 556.93 |
| Ross, Connor, J,20816 | 4228.72 | 0.00 | 3578.27 | 0.00 | 650.45 |
| Goel, Alicia, H,20423 | 4177.74 | 0.00 | 3578.27 | 0.00 | 599.47 |
| Guo, Brent, J,25945 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Torres, Sabrina, E,20425 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 0.00 | 4890.01 |
| Xie, Kelli, J,20452 | 6156.70 | 0.00 | 3578.27 | 0.00 | 2578.43 |
| Goel, Ricardo, T,25961 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Yuan, Deborah,12021 | 4043.46 | 0.00 | 3399.99 | 0.00 | 643.47 |
| Munoz, Casey, W,12570 | 2654.06 | 0.00 | 2049.10 | 0.00 | 604.96 |
| Rodriguez, Geoffrey,20817 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Lu, Willie,21191 | 4169.33 | 0.00 | 2443.35 | 0.00 | 1725.98 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Allen, Luis, C,26019 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Sanders, Devin, J,12014 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Kumar, Katie, P,12341 | 6840.62 | 0.00 | 2049.10 | 0.00 | 4791.52 |
| Perez, Ronald,25944 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Pal, Sheena, D,21197 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Vance, Meredith, B,20983 | 4178.73 | 0.00 | 3578.27 | 0.00 | 600.46 |
| Nara, Katrina, Z,24608 | 2120.93 | 0.00 | 1000.44 | 0.00 | 1120.49 |
| Perez, Molly,25941 | 1255.36 | 0.00 | 699.10 | 0.00 | 556.26 |
| Chapman, Clifford, C,21168 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Arun, Gerald,25940 | 1277.56 | 0.00 | 699.10 | 0.00 | 578.46 |
| Sai, Regina,21192 | 4229.32 | 0.00 | 2443.35 | 0.00 | 1785.97 |
| Andersen, Tracy,20815 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Becker, Kara,21167 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Yuan, Rafael, J,20625 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Nath, Cassie,24606 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Powell, Rachel,20818 | 4230.73 | 0.00 | 3578.27 | 0.00 | 652.46 |
| Chander, Alisha,12572 | 2611.41 | 0.00 | 2071.42 | 0.00 | 539.99 |
| Hernandez, Philip,21193 | 3905.52 | 0.00 | 2181.56 | 0.00 | 1723.96 |
| Anand, Bradley,19626 | 39.46 | 0.00 | 0.00 | 0.00 | 39.46 |
| Green, Jennifer,12571 | 2641.39 | 0.00 | 2071.42 | 0.00 | 569.97 |
| Cai, Willie, S,25960 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Dominguez, Walter,12576 | 2653.07 | 0.00 | 2049.10 | 0.00 | 603.97 |
| Rai, Bradley,19100 | 79.26 | 0.00 | 0.00 | 0.00 | 79.26 |
| Hernandez, Logan,12350 | 6791.75 | 0.00 | 2071.42 | 0.00 | 4720.33 |
| Rubio, Desiree, D,21189 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Yang, Tiffany, K,21215 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Torres, Theresa,21202 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Blanco, Larry, E,21216 | 4935.67 | 0.00 | 2443.35 | 0.00 | 2492.32 |
| Ruiz, Danny,24456 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rai, Grant, R,12573 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Raje, Lacey, T,12358 | 6787.76 | 0.00 | 0.00 | 2071.42 | 4716.34 |
Generated 2026-01-04 05:20:13.144 UTC