Excel poisoning #5: adding calcuted field to pivot table

Excel pivot table are very very usefull, but sometimes you need to add further “calculus” 🙂
How can add personal defined calculated fields to your pivot tables ?

Here is the solution, straight from office help: Edit a PivotTable or PivotChart formula

You may find info on creating, editing and deleting your personal formulas in pivot table. 😉

For short: select the pivot table, then Tools menu, Formula button, Calculated Fields menu, then the combobox listing the personal calculated fields. 😉

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: