+ Reply to Thread
Results 1 to 3 of 3

Can Pivot Table default settings be Changed?

  1. #1
    Registered User
    Join Date
    10-23-2015
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Can Pivot Table default settings be Changed?

    Hi All!
    I am creating a fairly simple pivot table, but am finding it very time consuming due to having to change all the defaults. SO data in source is a summary each month for 3 fields for a individual store, located in a specific country. WHen I pivot I want data summed by country for each of those fields each month. SO I put the country in the Row label. THen I want to take the 3 monthly field list items (so there are 27 right now lets call them fields A,B,C for January through September) and add tehm to the sum Values field as a SUM. So it would sum for January-Field A in Country=Australia. Pivot would then 27 columns and number of countries in the rows... What I am finding though is
    1)I can't select all the fields together and drag over to the values. Have to do it one at a time. I want to pick all the Field A's for the 9 months and put them together as they go in the field list so I can ultimately show trends month over month
    and
    2) WHen I do move each FIeld A over to the value field settings always defaults to COUNT. I want it to always default to SUM.

    Can anyone help me figure out how to change defaults to help expedite this? Once I get it built I will just have to add 3 columns to the report each month, so no issue, but I have to do this for multiple channels, and it is kicking my butt right now.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Can Pivot Table default settings be Changed?

    wiithdrawn....
    Last edited by protonLeah; 10-23-2015 at 05:25 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    10-23-2015
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Can Pivot Table default settings be Changed?

    Posting the sheet wont help. Its not the data. I am asking question about how to use excel to default setting a pivot table entry. The data is not important

+ 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: 12
    Last Post: 10-02-2014, 12:31 AM
  2. Pivot Table Value Field Settings Default Options
    By Bill fitz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-07-2013, 09:23 AM
  3. Replies: 0
    Last Post: 09-29-2011, 05:54 AM
  4. changing the default settings of pivot table
    By mub in forum Excel General
    Replies: 1
    Last Post: 01-29-2008, 12:03 PM
  5. [SOLVED] Can AutoSave's default settings be changed to one's preference?
    By SoNearRedmondICouldThrowWaterBombsAtThem in forum Excel General
    Replies: 3
    Last Post: 08-18-2006, 06:50 PM
  6. Pivot Table Field Settings Default value
    By Debra Dalgleish in forum Excel General
    Replies: 3
    Last Post: 11-02-2005, 06:20 PM
  7. [SOLVED] Pivot Table Field Settings Default value
    By MMesarch in forum Excel General
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM
  8. Pivot Table - Default Settings for Table Options
    By Nacho in forum Excel General
    Replies: 0
    Last Post: 02-25-2005, 02:06 PM

Tags for this Thread

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