+ Reply to Thread
Results 1 to 2 of 2

Measure not showing in pivot table field options list

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    594

    Measure not showing in pivot table field options list

    Hi,
    Can someone tell my why a measure does not show up in the field list for a pivot table, I've checked that nothing is hidden,
    the measure can be seen in data and diagram view. I've included a sample of the table cut down to small size, and one
    measure summing a column on the invoice header table to illustrate the point.

    Richard.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Measure not showing in pivot table field options list

    Hi Dicken,

    You have two fields named Product in different tables. I'd expect you are dragging down the other "Product" field in your Pivot which doesn't include the words you expect. ??
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. Pivot Table: Grand Total different measure from Column measure
    By chinneywow in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-07-2019, 06:22 AM
  2. Replies: 1
    Last Post: 01-15-2019, 08:54 PM
  3. [SOLVED] Showing Text in a Pivot Table - expanding the amount of options.
    By Jwilf in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-07-2016, 10:38 AM
  4. Field list not showing up when I try to do a pivot table
    By Njtrout in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-22-2016, 04:41 PM
  5. Pivot Table not showing the value filter options - only Top 10!
    By abhi.ko in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2014, 07:31 PM
  6. Replies: 0
    Last Post: 07-10-2013, 08:15 AM
  7. [SOLVED] pivot table not showing field list
    By bobteixeira in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-16-2006, 09:50 AM

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