Hi
Please see attached table - have created power pivot using power query from an excel file and created power pivots by departments as you will see in the tabs
We are trying to highlight the expiry/ review dates in col H and sort them to the top of the pivot tables by Name IN COL A
The pivot doesn't allow me to do so so i created a conditional formula to highlight the expiry dates.
As above we want to sort them at the top ie expiry dates at the top of each name.
Had to create a Master sheet table which does allow me to do this with a Macro "Sort" and slicer with Departments
Please see attached files - and if any one could point me in the right direction or help adjust files
Kind Regards
Sanjai
Please see attached table - have created power pivot using power query from an excel file and created power pivots by departments as you will see in the tabs
We are trying to highlight the expiry/ review dates in col H and sort them to the top of the pivot tables by Name IN COL A
The pivot doesn't allow me to do so so i created a conditional formula to highlight the expiry dates.
As above we want to sort them at the top ie expiry dates at the top of each name.
Had to create a Master sheet table which does allow me to do this with a Macro "Sort" and slicer with Departments
Please see attached files - and if any one could point me in the right direction or help adjust files
Kind Regards
Sanjai