I have sales figures that I need to rank, and they are represented in a pivot table. I can put the formula "=RANK(B6,B$6:B$54)" outside of the pivot table and it will work correctly.
How can I represent the sales ranks without having to retype the formula to the side of the pivot table each time the pivot table is refreshed or updated?
How can I represent the sales ranks without having to retype the formula to the side of the pivot table each time the pivot table is refreshed or updated?