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 headerthe header is always "A"s caption because the rowfield index is not based on its position.Please Login or Register to view this content.
I can change the position or return the position but is there a way to select a pivotfield based on its position?
Bookmarks