[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
| Cox, Taylor,11436 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Anand, Peter,14929 | 6646.58 | 0.00 | 3578.27 | 0.00 | 3068.31 |
| Chandra, Regina, M,15057 | 114.96 | 0.00 | 0.00 | 74.98 | 39.98 |
| Martin, Michele, J,27819 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Howard, Timothy,26356 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Deng, Misty,14861 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Taylor, Michael,27907 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Serrano, Daisy, P,24187 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 130.56 | 195.27 |
| Xie, Sheena,18041 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Roberts, Gabrielle, E,29432 | 1307.31 | 0.00 | 0.00 | 1307.31 | 0.00 |
| Suri, Terrance, C,21046 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Srini, Whitney,11560 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Chande, Kelsey, K,14846 | 6744.57 | 0.00 | 3578.27 | 777.34 | 2388.96 |
| Lal, Kelli, J,19173 | 1594.42 | 0.00 | 1000.44 | 0.00 | 593.98 |
| Long, Miguel,24853 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lopez, Jonathan, D,15103 | 107.85 | 0.00 | 0.00 | 71.58 | 36.27 |
| Gray, Savannah, E,13694 | 105.56 | 0.00 | 0.00 | 71.58 | 33.98 |
| Romero, Darren, A,19195 | 1637.38 | 0.00 | 1000.44 | 0.00 | 636.94 |
| Rana, Kristopher, W,22550 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Sanchez, Heidi,28438 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Munoz, Daisy,15081 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Sutton, Marshall,20862 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Alvarez, Ebony, M,28428 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Nara, Kara, E,24566 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nara, Louis, J,26901 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Pal, Michele,17814 | 133.93 | 0.00 | 0.00 | 29.98 | 103.95 |
| Perez, Holly, E,12376 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Tang, Alejandro, L,11542 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
Generated 2024-09-20 14:54:52.978 UTC