I want to only show the top 10 earners in each department (List hierachy E1 Department is top and E2 Employee below).
I have created a RANK that will give organize numbers lowest to highest based on each department, But the numbers do not "start over" for each department. So there is only one department, that has RANK 1, 2, 3 values etc. Then highest salary in another department starts on higher value but still fine as it is lowest rank in that department. But the problem is I now cannot do a filter based on 1-10. Do I need to update the RANK formula or can I somehow come around this with a boolean formula?