PIVOT - value defaults - for Excel 2007

M

mgville

FYI-

Excel 2007 users-

If you're like me and use pivots with tons of values that need calculations
other than the default, I found that you can change your value calculation
all at once.

Here's how...

Create your pivot table, select the values you want, click on the tool bar
and select 'Add-Ins'. Select the option called 'PIVOT', select 'Data
Fields...', SUM All Data.

Misty
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 pivot table using analysis services cube as data source 0
Excel 2007 pivot table: select multiple data easier 0
Affect a new connection to a pivot table 0
Word macro that can call cells out of Excel for a find and replace 0
Pivot Tables 2003 v 2007 0
about pivot table 1
Clear row label data in pivot table 2
Easy way to change Pivot table source files? 5

Top