How do I Add new formula columns in Pivot Table

Financialrep

New Member
Joined
Jan 25, 2018
Messages
2
Hi. How do I insert additional formula based columns that would calculate monthly/period variance from Target and YTD target variance from total months/periods?
 

Financialrep

New Member
Joined
Jan 25, 2018
Messages
2
DepartmentPP-1PP-2Month TargetVariance YTD Target Total Variance
A 3 6 1(5)2(7)
B 25 14 9(13)18(21)
C 8 18 16(17)326
D 6 1 70 147
F 14 14 8(13)16(12)
G 1 8 12(7)2415
H 4 0(3)0(4)
Total 57 65 53 (58) 106 (16)

<tbody>
</tbody><colgroup><col><col><col><col><col span="3"></colgroup>
 

Forum statistics

Threads
1,082,500
Messages
5,365,935
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top