Hello,
I have 5 data fieds in my pivot table. 2 of the data fields are "Period 1" and "Period 2". I'd like to add together these two source fields into one field displayed in the pivot table called "Year to date" in the pivot table.
Please could you tell me how to do directly within the pivot table without creating an extra column in the source data?
Many thanks,
Poiu
I have 5 data fieds in my pivot table. 2 of the data fields are "Period 1" and "Period 2". I'd like to add together these two source fields into one field displayed in the pivot table called "Year to date" in the pivot table.
Please could you tell me how to do directly within the pivot table without creating an extra column in the source data?
Many thanks,
Poiu