[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 30 >
30 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Vance, George, R,12038 | 66.76 | 0.00 | 0.00 | 2.29 | 64.47 |
Navarro, Teresa, E,25816 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
Suri, Lydia,13126 | 6815.08 | 0.00 | 0.00 | 2049.10 | 4765.98 |
Ortega, Janet, L,11754 | 8163.53 | 0.00 | 3399.99 | 2319.99 | 2443.55 |
Gill, Eddie, J,12715 | 74.54 | 0.00 | 0.00 | 64.97 | 9.57 |
Griffin, Rachel,18255 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
Perez, Patricia,25022 | 1564.92 | 0.00 | 0.00 | 1000.44 | 564.48 |
Cai, Candice,26747 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
Huang, Lisa, L,14102 | 3667.23 | 0.00 | 0.00 | 2910.90 | 756.33 |
Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 3804.08 | 0.00 |
Mitchell, Wyatt, A,14048 | 5123.74 | 0.00 | 0.00 | 2071.42 | 3052.32 |
Alonso, Ricky, S,14070 | 5618.93 | 0.00 | 0.00 | 3298.94 | 2319.99 |
Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 3598.83 | 0.00 |
Lopez, Bruce,23540 | 3626.82 | 0.00 | 0.00 | 3626.82 | 0.00 |
Pal, Donna, S,23572 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
Luo, Ashlee,23534 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
Beck, Ashlee, L,26666 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
Raje, Misty, A,23544 | 3971.01 | 0.00 | 0.00 | 2181.56 | 1789.45 |
Li, Stacey,14064 | 5694.21 | 0.00 | 0.00 | 3375.25 | 2318.96 |
Lal, Franklin, A,14101 | 3679.90 | 0.00 | 0.00 | 2888.58 | 791.32 |
Ye, Jenny,25036 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
Russell, Cassidy, N,26144 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
Beck, Cedric, L,22403 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
Li, Marshall,12687 | 6805.47 | 0.00 | 2071.42 | 2349.98 | 2384.07 |
Ashe, Misty, R,23129 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
Zhang, Clarence, M,13001 | 6799.43 | 0.00 | 2049.10 | 2332.28 | 2418.05 |
Vazquez, Ruben, B,14301 | 5142.75 | 0.00 | 0.00 | 2071.42 | 3071.33 |
Generated 2024-09-20 10:31:44.246 UTC