[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 64 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Xie, Mario,13687 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 | 0.00 |
| Rai, Keith, W,16396 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 | 0.00 |
| Shan, Mario,25271 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 | 0.00 |
| Kapoor, Carolyn, M,16459 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 | 0.00 |
| Brown, Joseph, M,28042 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Blanco, Lee, M,16660 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 | 0.00 |
| Ye, Dennis, M,16638 | 5974.23 | 0.00 | 3578.27 | 0.00 | 2395.96 | 0.00 |
| White, Jonathan, A,24703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Lopez, Jason, R,28022 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Rai, Dale, E,21739 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 | 0.00 |
| Ross, Samantha, R,27918 | 5998.61 | 0.00 | 3578.27 | 0.00 | 2420.34 | 0.00 |
| Foster, Melanie,14572 | 3016.07 | 0.00 | 699.10 | 0.00 | 2316.97 | 0.00 |
| Ruiz, Jill, P,14423 | 141.91 | 0.00 | 0.00 | 0.00 | 141.91 | 0.00 |
| Guo, Lacey,16744 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Watson, Jan, K,13680 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 | 0.00 |
| Luo, Lindsay,13514 | 5973.24 | 0.00 | 3578.27 | 0.00 | 2394.97 | 0.00 |
| Lopez, Heidi,11052 | 8131.32 | 0.00 | 3374.99 | 2337.27 | 2419.06 | 0.00 |
| Sanders, Andrea, L,27917 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Ye, Karen, L,25476 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Zheng, Laura,16701 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 | 0.00 |
| Zhang, Jason, L,12796 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 | 0.00 |
| Foster, Vanessa,16372 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 | 0.00 |
| Goel, Derek,17045 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 | 0.00 |
| Collins, Lucas, T,21921 | 4142.75 | 0.00 | 3578.27 | 0.00 | 564.48 | 0.00 |
| Gutierrez, Natasha,17048 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 | 0.00 |
| Raman, Patricia, T,16702 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 | 0.00 |
| Perez, Mayra,17971 | 2435.08 | 0.00 | 699.10 | 0.00 | 1735.98 | 0.00 |
| Andersen, Carl, J,11057 | 8088.04 | 0.00 | 3374.99 | 0.00 | 4713.05 | 0.00 |
| Pal, Mitchell, R,16742 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 | 0.00 |
| Henderson, Vanessa,13538 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 | 0.00 |
| Rana, Phillip,13543 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 | 0.00 |
Generated 2026-01-04 04:43:27.860 UTC