[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 23 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Green, Jennifer,12571 | 2641.39 | 0.00 | 2071.42 | 0.00 | 569.97 |
| Jai, Alvin,19599 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Griffin, Rachel,18255 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
| Lin, Jorge,27593 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Shen, Dustin,27974 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Pal, Nichole, J,26741 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ramos, Monique,16495 | 6002.23 | 3578.27 | 0.00 | 0.00 | 2423.96 |
| Nara, Calvin, J,11367 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Dominguez, Jimmy,21959 | 4702.39 | 0.00 | 0.00 | 2181.56 | 2520.83 |
| Weber, Jarrod, M,14859 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Martinez, Abby,29333 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Ms., Robinson, Rebecca, A.,11913 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Serrano, Leslie, T,14014 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Jai, Drew, M,21562 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Murphy, Alexa,18276 | 6106.60 | 0.00 | 3578.27 | 0.00 | 2528.33 |
| Raje, Carly, J,15576 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Kapoor, Pedro, H,24229 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Munoz, Latasha,11967 | 8153.02 | 0.00 | 3374.99 | 0.00 | 4778.03 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Shen, Katie, A,20283 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Xie, Dawn,21391 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Carlson, Billy, C,19667 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 0.00 | 2049.10 | 618.98 |
| Ruiz, Marvin, R,18796 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
Generated 2025-12-21 19:45:05.774 UTC