If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing field settings on multiple columns in pivot report...How
You have brought up a pivot report but it defeaults to count for all columns.
Can you change all to max with one operation? Thanks |
#2
|
|||
|
|||
Changing field settings on multiple columns in pivot report...How
You can't manually change all the calculations to MAX with one step.
You can change each field individually, by double-clicking on it, and changing the summary function. Or, you can use programming to change all the data fields. For example: Sub MaxAllData() 'changes data fields to MAX Dim pt As PivotTable Dim pf As PivotField For Each pt In ActiveSheet.PivotTables For Each pf In pt.DataFields pf.Function = xlMax Next pf Next pt End Sub Wayne wrote: You have brought up a pivot report but it defeaults to count for all columns. Can you change all to max with one operation? Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
sorting data in a report | David | Setting Up & Running Reports | 21 | October 14th, 2005 03:05 PM |
Changing multiple field sizes to same size | MarkB | Database Design | 6 | September 17th, 2005 06:57 PM |
Concatenating multiple values into a single field on a report | Kevin | Running & Setting Up Queries | 8 | July 16th, 2004 03:31 PM |