+ Reply to Thread
Results 1 to 2 of 2

Show value instead of count or sum in Pivot Table

  1. #1
    Forum Contributor
    Join Date
    01-28-2013
    Location
    sweden
    MS-Off Ver
    Excel 2010
    Posts
    108

    Show value instead of count or sum in Pivot Table

    Hi,

    I am trying to use a pivot table to make a report on different recipe.

    I want ingredients grouped in type of meal in rows and properties of each ingredient for each recipe in columns. I dont want to show count or sum of "Type of measure", e.g dl, but the actual metric used.

    I attached example of a file and highlighted columns where I want to show the actual value in red. Is this even possible with a pivot table?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Show value instead of count or sum in Pivot Table

    Something like this?
    Attached Files Attached Files

+ 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 data, how to show the data w/o count in the duplicate data
    By Ladyeve1023 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-17-2017, 01:03 AM
  2. 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
  3. [SOLVED] Pivot Table Summary -- Part #'s do not show in Pivot but data is in worksheet
    By maryren in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-19-2013, 10:51 AM
  4. [SOLVED] Multiple Columns in Pivot Table (but don't show in Pivot Chart)
    By Gideon1973 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-23-2012, 10:57 AM
  5. Simple pivot table to show count by date?
    By bu-chan in forum Excel General
    Replies: 1
    Last Post: 08-17-2010, 11:36 AM
  6. Pivot table filter data field to show items with count more than n
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2010, 07:36 PM
  7. Replies: 1
    Last Post: 02-09-2010, 06:16 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