[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 972 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Arun, Donald, B,16933 | 94.96 | 0.00 | 0.00 | 0.00 | 94.96 |
| Xie, Tara,19912 | 3427.39 | 0.00 | 0.00 | 1000.44 | 2426.95 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 0.00 | 57.95 |
| Wu, Kelli, T,15621 | 5977.74 | 0.00 | 3578.27 | 0.00 | 2399.47 |
| Liu, Jamie, J,19301 | 1590.42 | 0.00 | 1000.44 | 0.00 | 589.98 |
| Sanz, Pedro,18168 | 6907.55 | 0.00 | 0.00 | 2181.56 | 4725.99 |
| Wang, Barbara, M,15652 | 5160.08 | 0.00 | 3578.27 | 0.00 | 1581.81 |
| Tang, Nichole, C,15630 | 5136.37 | 0.00 | 3578.27 | 806.76 | 751.34 |
| Roberts, Mackenzie,23599 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Shan, Russell,19500 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Jai, Shawna, W,17750 | 2888.53 | 0.00 | 0.00 | 2181.56 | 706.97 |
| Price, Wyatt,12336 | 78.98 | 0.00 | 0.00 | 28.99 | 49.99 |
| Jimenez, Robyn, M,12861 | 4394.06 | 0.00 | 0.00 | 2049.10 | 2344.96 |
Generated 2024-11-11 03:56:55.128 UTC