Not able to create pivot due to diff variables

[abraham30]

Hello Everyone!

In the attached sheet, I want a pivot which display top 3 variables with highest number of records (Var1_ERR to Var5_ERR) based on the sector, report type etc.

I am not able to create the pivot to arrange the data properly. can anyone help

e.g. Suppose Question is --> display top 3 variables with number of records from the master sheet

My pivot should display like below
Var3_ERR 596
Var1_ERR 261
Var4_ERR 242

Advance thanks for your help