I have a flip button for a pivot table that swaps two row fields over so it can group "A"s in "B" or "B"s in "A".
however when I try to rename the header
Please Login or Register  to view this content.
the header is always "A"s caption because the rowfield index is not based on its position.
I can change the position or return the position but is there a way to select a pivotfield based on its position?