Changing the "Difference From" setting in Pivot Field

D

Dan

I am using the "Show Data As:" element in the Pivot Table
Field Options to display the "Difference From" one field
group to another. When the need arises to change
these "Base Items" (dates in this case), is there any way
to link it directly into the spreadsheet that has the
Base Items already there? In other words, can it change
the Base Item automatically based on displayed Based
Items in the Pivot Table?

Thanks,
Dan
 
Top