nathankennedy77
New Member
- Joined
- Feb 23, 2005
- Messages
- 47
Hello All,
I have searched the forum and although I have found material that has helped I still cannot get this to work.
I have a Pivot table that I would like to add a change column to, example below;
Department June2010 Oct2010 Change (New Column)
IT 5 4 -1
HR 7 8 1
MKT 10 8 -2
Of course no issues with a normal excel formula, however can this be done in a PIVOT. I have played with the various native options in Field settings and calculated fields but cant get it working. Any suggestions or advice would be appreciated.
Kind Regards
Nathan
I have searched the forum and although I have found material that has helped I still cannot get this to work.
I have a Pivot table that I would like to add a change column to, example below;
Department June2010 Oct2010 Change (New Column)
IT 5 4 -1
HR 7 8 1
MKT 10 8 -2
Of course no issues with a normal excel formula, however can this be done in a PIVOT. I have played with the various native options in Field settings and calculated fields but cant get it working. Any suggestions or advice would be appreciated.
Kind Regards
Nathan