Hello Luke, To clarify - What i am looking for, I've uploaded the file on below link
http://www.speedyshare.com/rtzxu/Top10-Filter-Report.xlsx
1st tab 'Dashboard' - User will select Plant & Month from dropdown listbox &
then materials with highest variance% needs to be shown in the table as...
Hello all, I am not sure - If similar request has been posted on this forum.
I got data of 4 fields - 1) Month, 2) Plant 3) Material & 4) Variance value (Calculated using Pivot formula = Actual / Scheduled)
Pivot has the option to filter the Top 10 value on field 'Variance value'
But it...