1) I need to create a Pivot which would have Year as my dimension (ROWS) and one new dimension (which consists of all Field1,Field2 & Field3 values) as COLUMNS
2) Also I want to create a dynamic logic such that if there is any new value added in any of the Fields( i.e Field1,2,3) It should populate the sum(Sales) directly without making any script changes.