[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 48 >
48 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rai, Nina,14018 | 63.87 | 0.00 | 0.00 | 0.00 | 63.87 |
| Shen, Nichole,12999 | 6840.46 | 0.00 | 0.00 | 2071.42 | 4769.04 |
| Zhu, Colleen,17252 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Moreno, Dana, D,15033 | 3797.40 | 0.00 | 0.00 | 2071.42 | 1725.98 |
| Price, Isabella, L,17278 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Butler, Austin, W,18293 | 74.24 | 0.00 | 0.00 | 74.24 | 0.00 |
| Jai, Melvin, M,27722 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Nara, Willie,24460 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Davis, Morgan, J,27359 | 1344.47 | 0.00 | 0.00 | 782.99 | 561.48 |
| Malhotra, Tina, C,27584 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Deng, Tracy, E,21978 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Moyer, Meghan,21220 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 0.00 | 2520.83 |
| Deng, April,11117 | 8184.99 | 0.00 | 3399.99 | 2365.94 | 2419.06 |
| Lu, Ronnie,19950 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Navarro, Carolyn,11069 | 8104.05 | 0.00 | 3399.99 | 2319.99 | 2384.07 |
| Ortega, Dwayne, C,24615 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Rubio, Beth,20240 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Gill, Orlando,21360 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Prasad, Brett, A,20262 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Schmidt, Kaitlin,13628 | 191.25 | 0.00 | 0.00 | 0.00 | 191.25 |
| Bryant, Fernando, M,20609 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Suri, Mayra, M,15729 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 |
| Yuan, Ricardo,16674 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Kumar, Tamara, A,25222 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| She, Nichole, M,11909 | 8105.31 | 0.00 | 3374.99 | 0.00 | 4730.32 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Shan, Derek, R,19782 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Gutierrez, Jay, C,13155 | 226.95 | 0.00 | 0.00 | 0.00 | 226.95 |
| Martinez, Douglas, C,22841 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Parker, Mason, W,25923 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Sanz, Eddie, A,19580 | 173.93 | 0.00 | 0.00 | 0.00 | 173.93 |
| Vazquez, Shannon,26035 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Gonzales, Hunter,26570 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Rana, Bryant,21878 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Navarro, Rodney, L,29309 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Lopez, Kristopher, L,21560 | 4702.39 | 0.00 | 0.00 | 2181.56 | 2520.83 |
| Suarez, Meghan, L,22177 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Zhu, Damien, M,15822 | 43.21 | 0.00 | 0.00 | 0.00 | 43.21 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| He, Karen, C,27861 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2049.10 | 1581.83 |
| Lopez, Cesar,17500 | 156.96 | 0.00 | 0.00 | 0.00 | 156.96 |
| Madan, Carla, D,28135 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Raji, Corey,25058 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lopez, Deanna, L,25119 | 2148.21 | 0.00 | 0.00 | 1000.44 | 1147.77 |
| Xu, Randy, S,11969 | 8173.02 | 0.00 | 3399.99 | 0.00 | 4773.03 |
| Shen, Bonnie,21405 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
Generated 2025-12-22 04:09:54.929 UTC