ADD a calculating filed in pivot

User avatar
sal21
PlatinumLounger
Posts: 4355
Joined: 26 Apr 2010, 17:36

ADD a calculating filed in pivot

Post by sal21 »

About the iamge attached, i need to insert a calculating fild in pivot...
Example:
in E12 the name of filed in this case DIFFERENCE

In E13 diff from C13-D13
In E14 diff from C14-D14
In E15 diff from C15-D15
...

note:
Tks in other case for assistence in my old Query prob but all my query are all without success :scratch: :sad:
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78487
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: ADD a calculating filed in pivot

Post by HansV »

Click on AGG or one of the dates of the AGG field.
On the PivotTable toolbar, click PivotTable | Formulas | Calculated Item
Type DIFFERENCE in the Name box.
In the Formula box, enter

='30/12/2010'-'30/01/2011'

Click Add, then OK.
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4355
Joined: 26 Apr 2010, 17:36

Re: ADD a calculating filed in pivot

Post by sal21 »

HansV wrote:Click on AGG or one of the dates of the AGG field.
On the PivotTable toolbar, click PivotTable | Formulas | Calculated Item
Type DIFFERENCE in the Name box.
In the Formula box, enter

='30/12/2010'-'30/01/2011'

Click Add, then OK.
Error!
Last edited by sal21 on 09 Feb 2011, 13:16, edited 1 time in total.

User avatar
HansV
Administrator
Posts: 78487
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: ADD a calculating filed in pivot

Post by HansV »

I'd have to see the workbook.
Best wishes,
Hans

User avatar
rory
5StarLounger
Posts: 817
Joined: 24 Jan 2010, 15:56

Re: ADD a calculating filed in pivot

Post by rory »

You are trying to add a calculated field - as Hans said, you need a calculated item.
Regards,
Rory