1 of 1 people found this helpful
Add Data source filter select "F1 " and "Exclude Region".Use below snapshots for steps to do it.
On data source connection window, Rename the column header "F1,F2,F3 F4" as "Region,2014,2015,2016"
You will find the final resultant data source like below snapshot.
Create Pivot while connect to datasource.