[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 41 > < TAKE 48 >
48 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lal, Mitchell, C,20403 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lopez, Dominic, B,27590 | 1189.46 | 0.00 | 0.00 | 0.00 | 1189.46 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Prasad, Gerald, B,12035 | 81.24 | 0.00 | 0.00 | 0.00 | 81.24 |
| Liang, Lacey, A,15719 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Arun, Barry,27700 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kapoor, Veronica, G,20253 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 0.00 | 221.91 |
| Madan, Michele, A,12676 | 6859.46 | 0.00 | 0.00 | 2071.42 | 4788.04 |
| Navarro, Kristy, J,19570 | 74.94 | 0.00 | 0.00 | 0.00 | 74.94 |
| Moreno, Melody, R,11760 | 274.92 | 0.00 | 0.00 | 0.00 | 274.92 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Carlson, Joy,13981 | 124.21 | 0.00 | 0.00 | 0.00 | 124.21 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 0.00 | 4492.45 | 0.00 |
| Patel, Kaitlin, L,16615 | 95.84 | 0.00 | 0.00 | 0.00 | 95.84 |
| Srini, Roy,24888 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Jai, Latoya, S,21229 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Foster, Hunter, A,20269 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Carl, C,28950 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Griffin, Brianna, K,16487 | 73.24 | 0.00 | 0.00 | 0.00 | 73.24 |
| Liu, Warren,15014 | 3860.87 | 0.00 | 0.00 | 2071.42 | 1789.45 |
| Lu, Crystal, A,15145 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Perez, Henry,26752 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Fernandez, Brandy, B,22958 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Malhotra, Joel, E,16343 | 58.25 | 0.00 | 0.00 | 0.00 | 58.25 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Munoz, Latasha,11967 | 8153.02 | 0.00 | 3374.99 | 0.00 | 4778.03 |
| Carlson, Marc, W,17501 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 0.00 | 4794.04 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Goel, Bethany,27511 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Thomas, Christopher, M,20242 | 6068.45 | 0.00 | 3578.27 | 0.00 | 2490.18 |
| Wang, Jeffery, E,18188 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Serrano, Shannon, R,18303 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Hernandez, Diana, F,11038 | 6437.33 | 0.00 | 3374.99 | 0.00 | 3062.34 |
| Lin, Dennis,16169 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Harrison, Colleen, L,20219 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Beck, Donna, J,18247 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Goel, Christine, A,21231 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Ruiz, Kari, L,12695 | 192.97 | 0.00 | 0.00 | 0.00 | 192.97 |
| Martinez, Ethan, C,20260 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Yuan, Marshall, P,19978 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Shan, Shawna, K,27869 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
Generated 2026-01-04 05:40:28.125 UTC