Total field in Pivot

**mshtuhin** · 11-19-2009, 09:23 AM

here in this data sheet there is no field named "Sum of total CM1" whereas it is in pivot table!

can anyone tell me how can i do that, pls

Note: this pivot table were copied from original file that i found. But cannot attach original file as original size is 2mb

**DonkeyOte** · 11-19-2009, 09:46 AM

It is a calculated field, google and you will find lots of tutorials on the concept.

**Richard Buttrey** · 11-19-2009, 09:50 AM

Hi,

This is the default name that's automatically created to let you know that it is summing the fields you've named January 2009, February 2009 etc.

If you want to change this, right click in the PT in each column in turn, select 'Field Settings' and change the Name to something else. Note that you can't use exactly the same name as the PTs field name. So for instance if you do want just January 2009 you'll need to add a trailing space. i.e. "January 2009 "

Rgds

late edit. Sorry, misunderstood the Q. Follow Donkey's advice

**mshtuhin** · 11-19-2009, 09:09 PM

thanks to you all for attending. however my query is somewhat different. in pivot sheet you will find column K named "Sum of Total CM1" which is missing in "raw" sheet!!

I have no issue with January, February ... but surprised to see how this column appeared. have searched google and other sources but honestly no such solution.

and i do not have knowledge of VBA. now I am attaching the original file. can u please check now to help plsssss

thx
Tuhin

**Richard Buttrey** · 11-19-2009, 10:21 PM

Please re-read what Donkey said. He pointed out that this was a calculated field which has been added to the pivot table. It does not exist in the Raw data sheet. That's the whole point of calculated fields.

Click in the PT, choose Insert, Select calculated field and click the drop down name box and you'll see your CM1 name.

Rgds

**mshtuhin** · 11-20-2009, 05:08 AM

yes i got it. thank u so much

brgds/Tuhin

**DonkeyOte** · 11-22-2009, 04:22 PM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

**mshtuhin** · 11-22-2009, 08:01 PM

Extremely sorry for violating the rule due my unawareness. I did two mistake, 1. posted before reading forum rule 2. Violated the rule, and really feeling shy much.

I beg pardon to all who spent their valuable time even though it has already been solved. Already provided the link to other forum as Donkey advised.

Going forward surely will adhere to forum rule accordingly.

Sorry again for the mistake.

brgds/Tuhin