Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Calculate fields (Pivot Tables)

  Asked By: Erica    Date: Nov 30    Category: MS Office    Views: 1279
  

This is not a VBA problem. It's easier.

The fact is:

I have a Pivot Table with 3 fields

1. Name by store
2. Budget units (Total)
3. Results (Units) This is calculate by count of the field.

I need to add a calculate field, with a formula

I used a Pivot Table option, formula, calculate field

The field Total appears 'Total' and the field Units appears without (') like
this Units.

I tried to add a calculate field and write a formula:

'Total'-Units.

The result does not work well.

Any one knowa, what's happening?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Tamara Nguyen     Answered On: Nov 30


I tried this out and it seems that you have to place two more quotes after
'Total' i.e. 'Total'''

So your formula  in the calulate field  should be ='Total'''-Units

 
Didn't find what you were looking for? Find more on Calculate fields (Pivot Tables) Or get search suggestion and latest updates.




Tagged: