+ Reply to Thread
Results 1 to 5 of 5

Excel 2013 Pivot Table - Setting a default value label (MIN, MAX etc)

  1. #1
    Registered User
    Join Date
    01-28-2015
    Location
    Peoria, Illinois
    MS-Off Ver
    2013
    Posts
    23

    Excel 2013 Pivot Table - Setting a default value label (MIN, MAX etc)

    I'm working in Excel 2013.

    The set up:
    I have a pivot table with 48 columns of data and I want to set the default VALUE to MIN or MAX or AVERAGE. I see how I can set each column individually in the VALUES field or I can right-click on a column and select SUMMARIZE VALUES BY and do each column individually.

    My question:
    Is there an easier way to select all columns and set the VALUE to my desired condition??

    Thanks!

    -Troy

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Excel 2013 Pivot Table - Setting a default value label (MIN, MAX etc)

    VBA is the easiest way, and I keep a macro around for just that.

    I despise going through 60-100 columns trying to change it from a count to a sum or whatever...

    Please Login or Register  to view this content.
    Copy and paste that into the VBE into a new general module and hit run. Pow, done.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    01-28-2015
    Location
    Peoria, Illinois
    MS-Off Ver
    2013
    Posts
    23

    Re: Excel 2013 Pivot Table - Setting a default value label (MIN, MAX etc)

    Thanks mikeTRON!
    Excellent coding for modifying all pivot tables! I have multiple tables that have 50 columns of data and it's brain numbing to say the least to go through them for updating the values.
    I can mark this question solved, though I have a follow-on question for the code in that instead of looking at all tables, can I just say I want "PivotTable25" changed or have an individual pivot table selected and only update that table.
    I am still new to coding VBA and am having an issue identifying only the single table.
    Thanks!

    -Troy

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Excel 2013 Pivot Table - Setting a default value label (MIN, MAX etc)

    Yeah you can call out a specific table.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-28-2015
    Location
    Peoria, Illinois
    MS-Off Ver
    2013
    Posts
    23

    Re: Excel 2013 Pivot Table - Setting a default value label (MIN, MAX etc)

    Perfect!
    Thanks again mikeTRON.

    -Troy

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 06-19-2014, 12:59 PM
  2. Can't sort pivot table in Excel 2013
    By kleemc in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-06-2013, 08:55 AM
  3. Text as value in pivot table . is that possible in excel 2013
    By onenessboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2013, 08:37 AM
  4. Replies: 0
    Last Post: 09-29-2011, 05:54 AM
  5. [SOLVED] pivot table format report - setting default
    By stevep in forum Excel General
    Replies: 0
    Last Post: 12-14-2005, 11:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1