+ Reply to Thread
Results 1 to 2 of 2

On selection some PivotTable 'Fields' go to 'Rows' instead of 'Values'

  1. #1
    Registered User
    Join Date
    08-12-2018
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    1

    On selection some PivotTable 'Fields' go to 'Rows' instead of 'Values'

    I use pivot tables a lot.

    But I cannot figure out what make certain field to go to Rows, while others to Values when I click the tick box through mouse.

    Normally I always want that whatever field I select go to the Value section.

    Because some don't, I have to manually drag and drop them every time.

    Any way, I can customize this behavior of field?

    Dont want Percentage to go to Rows, it should go to Value area like Numbers does (shown below)
    BTPia.png

    Following is what I want ideally, field to go to Value section, instead of Rows.
    b3fOl.png

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,908

    Re: On selection some PivotTable 'Fields' go to 'Rows' instead of 'Values'

    That usually means that the data in that field is not being seen as numeric. If you add it to the values area, does it sum properly? If so, then only some of it is not numeric.

+ 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. PivotTable Calculated Fields
    By Madlock in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-06-2016, 02:01 AM
  2. Hiding fields in PivotTable
    By kollur in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-16-2015, 10:10 PM
  3. Shift rows below PivotTable down when PivotTable expands (PowerPivot)
    By hektisk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2012, 10:19 PM
  4. [SOLVED] Need combobox selection to set default values of other fields in form.
    By 0612Man in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2012, 12:52 AM
  5. [SOLVED] Print PivotTable - Page fields
    By Koen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2006, 04:35 AM
  6. Combing Fields in a PivotTable???
    By ddawg09 in forum Excel General
    Replies: 2
    Last Post: 02-06-2006, 10:47 PM
  7. pivottable calculated fields
    By HelpAl in forum Excel General
    Replies: 4
    Last Post: 12-08-2005, 06:55 PM

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