I am having sheet which shows the data for employees Shift wise. I have used the pivot table to show the data employee wise..
the problem is wherever I am using Consolidation Function as SUM the data is coming correctly but when i am using Consolidation Function as Average , the values are getting different.
for this reason I want to calculate in pivot table..
So Please If any one can tell me how to calculate or apply formulas in pivot table..
I tried pivotTable.AddCalculatedField but I think it will apply to already existing data of sheet..
I want to apply formulas to datafields of pivot table ..
I hope .. understand my requirement..