Good afternoon,
I have a spreadsheet with pivot tables calculating the top 10 accounts by product type. I have to the side of the pivot table a formula that gives the % of total top 10. Problem is some products do not have a top 10, they may only have a top 8 and then the total is not in the location referenced by the formula and I get an error result. Is there a way to have the formula use the last cell of column B in the pivot table so that it will always be correct?
Thank you,
N
Bookmarks