Pivot Table Default Setting

R

Registrar

Can you change the default setting in Pivot Table? For Example if everytime I
do a pivot table I do not want it to give me subtotals can I default it that
way instead of always changing the setting.
 
M

Matt S

You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT.
Otherwise, it will SUM.
 

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

Pivot Table subtotals 1
can i add subtotals to subtotals in a pivot table? 1
Pivot Table Options 'Fields per column' 1
Pivot Table date format 1
Pivot table - undo of a macro 1
Pivot Table Page Break Refresh Problem 0
Filtering within Pivot Table 1
pivot table data 2

Top