I have a list of parts in a sub-summary report that are sorted by quantity of each part that were used (ordered from highest to lowest).
I want to be able to ideally put a horizontal line across the report after the 10th highest part (so that i can clearly see the top 10 highest used parts).
Can anyone suggest a way to do this??
If a line across the report is not possible, is there formula/calculation that i could add to the field's conditional formatting in order to make it easy to see the highest 10 parts?
I would be very grateful for any help.