In a pivot table, data's are available for month wise, below of the pivot, totaled for the respective one month for ex: - ( =GETPIVOTDATA("Sum of 17.02.12",$C$3,"shore indicator1","ONSHORE") in the next cell, need to copy the same formula but the date should get change as per the date available...