Thanks, though it should be dynamic to the pivot table. I want to apply the formula to the contents of the pivot table and have it automatically resize with the pivot table. Make sense? Dragging not what I'm trying to do.