+ Reply to Thread
Results 1 to 2 of 2

Excel doesn't allow move column in pivot table

  1. #1
    Registered User
    Join Date
    10-06-2020
    Location
    UK
    MS-Off Ver
    Excel2019
    Posts
    1

    Excel doesn't allow move column in pivot table

    Hi all.

    Excel doesn't allow me move column with values. It says I have to use field list to change report.

    Is it possible to move it?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    12,940

    Re: Excel doesn't allow move column in pivot table

    The only fields in the Values area are Qty and Actual. If you would like the Qty column displayed to the right of the Actual column then drag Sum of Qty below Count of Actual in the Values area of the field list.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Move Pivot Table to align with last row of other column
    By Lochlan97 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2020, 04:19 AM
  2. [SOLVED] Formula doesn't move with rows when using sort in a table
    By boba7523 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 02-23-2020, 09:26 PM
  3. [SOLVED] How To Move A Column In A Pivot Table
    By zanshin777 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-13-2015, 10:38 AM
  4. Pivot Report doesn't show current records but they are in pivot table
    By dixiecricket in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-16-2015, 11:25 AM
  5. Excel pivot table doesn't show duplicate entries?
    By resmark1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-07-2015, 11:40 AM
  6. move column total in pivot table to begining
    By flow23 in forum Excel General
    Replies: 0
    Last Post: 12-08-2005, 09:10 AM
  7. Pivot table: order, move to column
    By excelhappy in forum Excel General
    Replies: 0
    Last Post: 05-09-2005, 02:31 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