excel software training - pivot table deafults

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training - Pivot Table Deafults

excel software training - Pivot Table Deafults

resolvedResolved · Low Priority · Version Standard

Paul has attended:
Excel Advanced course

Pivot Table Deafults

My totals within my pivot tables are defaulting to "Count" rather than "Sum". Can I change the defaults anywhere?

RE: Pivot Table Deafults

If you drop a non-numerical field into the Data area on a pivot table, it will default to COUNT. If the field is numerical, then the default is SUM.

Click on "field settings" to modify the function.

RE: Pivot Table Deafults

The fields in question are "Sales" and "Targets" and therefore numerical. I have managed to change them on the field settings.


 

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips


Server loaded in 0.48 secs.