Hi I am struggling with find the top 10 Overbooked depts. My requirement seems to be easy. I need to find the Top 10 Overbooked where the “ACTUAL HEAD BOOKING + EQUIVALENCE > ASSIGNED BUDGET”

The underlying data is vast i.e 70,000 rows plus.

The data is simple.
FY Report PT Dept Budget Type Programme PT Total Apr May Jun
FY2011 PT-20 REQUIRED OPERATE Program 1 PT-2 2 2 2
FY2011 PT-21 ACTUAL HEAD BOOKINGS Program 2 PT-2 1 1 1
FY2011 PT-21 EQUIVALENCE Program 3 PT-2 2 2 2
FY2012 PT-21 FORECASTED BUDGET Program 4 PT-2 3 3 3
FY2012 PT-22 ACTUAL HEAD BOOKINGS Program 5 PT-2 1 1 1
FY2012 PT-30 EQUIVALENCE Program 6 PT-3 1 1 1
FY2012 PT-30 REQUIRED OPERATE Program 7 PT-3 1 1 1

Question_pivot_2.JPG
Question_pivot_1.JPG


I have tried the Filter whereby I can ‘filter by’ the TOP 10 values but I cannot get data in the same rows of the pivot according to my formulae. There are several data slicers acting on the PIVOT table therefore dynamically changing the table applying the various Slicer filters. I need to keep the solution within the Pivot table so that the TOP 10 Overbooked (and Underbooked) change depending upon the Slicer Selections i.e. by Dept or Program etc..

Essentally, I need to get ACTUAL HEAD BOOKING + EQUIVALENCE > ASSIGNED BUDGET on the same row. I have tried various Calculated field etc but with little luck. All the

Any assistance would be greatly appreciated.
Thanks in advance. Kuldip.