[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 < SKIP 156 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Terrance, T,14217 | 139.45 | 0.00 | 0.00 | 0.00 | 139.45 |
| Rodriguez, Douglas, W,19652 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Gutierrez, Lawrence, M,19564 | 5293.24 | 0.00 | 3578.27 | 0.00 | 1714.97 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 0.00 | 2049.10 | 4813.04 |
| McDonald, Kaitlin,18493 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Diaz, Ruben, A,25136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lopez, Mayra, E,27356 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Liang, Rosa, L,19770 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Ramos, Meredith, A,23307 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Li, Dawn, B,13962 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Shen, Misty, S,25019 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Lal, Kurt, R,14015 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Martinez, Ivan,27872 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Dominguez, Rebekah,27877 | 1228.83 | 0.00 | 0.00 | 0.00 | 1228.83 |
| Anderson, Richard, G,24924 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Madan, Patricia, L,22988 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 |
| Munoz, Felicia, D,20406 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Wu, Marshall, J,15590 | 4440.05 | 0.00 | 0.00 | 2049.10 | 2390.95 |
| Jai, Katrina,13044 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Torres, Bailey,18259 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Washington, Julian, C,23330 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Vazquez, Ruben, B,14301 | 5142.75 | 0.00 | 0.00 | 2071.42 | 3071.33 |
| Allen, Logan,15812 | 81.25 | 0.00 | 0.00 | 0.00 | 81.25 |
| Lopez, Deanna, L,25119 | 2148.21 | 0.00 | 0.00 | 1000.44 | 1147.77 |
| Guo, Ernest,25717 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Hernandez, Ross,14677 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Sun, Jaclyn,18211 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Sanchez, Michele,23543 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Lopez, Brandy, S,18199 | 99.94 | 0.00 | 0.00 | 0.00 | 99.94 |
| Raji, Maurice, C,20619 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
Generated 2025-12-24 07:38:16.757 UTC