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
ADD a calculating filed in pivot
-
- PlatinumLounger
- Posts: 4368
- Joined: 26 Apr 2010, 17:36
ADD a calculating filed in pivot
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: ADD a calculating filed in pivot
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.
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
Hans
-
- PlatinumLounger
- Posts: 4368
- Joined: 26 Apr 2010, 17:36
Re: ADD a calculating filed in pivot
Error!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.
Last edited by sal21 on 09 Feb 2011, 13:16, edited 1 time in total.
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 5StarLounger
- Posts: 818
- Joined: 24 Jan 2010, 15:56
Re: ADD a calculating filed in pivot
You are trying to add a calculated field - as Hans said, you need a calculated item.
Regards,
Rory
Rory