+ Reply to Thread
Results 1 to 3 of 3

Pivot table issues

  1. #1
    Registered User
    Join Date
    03-09-2010
    Location
    Loughborough
    MS-Off Ver
    2011
    Posts
    19

    Post Pivot table issues

    Hi All

    I have created a pivot table from source data which are number values. However the pivot is displaying zeros instead of the values I want it to from the source data. The source data field are formulae for example =conditioning_data!F2. Effectively I have created another sheet to simplify things for me from another sheet (namely 'conditioning_data). On that sheet, the formula which produces a value for me is similar to this:

    =IF(J2="", "-", IF(J2<60, "1", IF(J2<=79, "2", IF(J2<=100, "3", IF(J2<=120, "4", IF(J2>120, "5"))))))

    Is there a simple trick I can employ which will allow the string value that is returned to display in the pivot table? I have selected MAX on the pivot table, but it is still displaying the 0.

    Any help would be greatly appreciated.

    Many thanks

    David

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,146

    Re: Pivot table issues

    Try removing the double quotes from the returned numbers. That will make them rel numbers instead of text strings
    Eventually post your sheet/wbk with some data and expected results

  3. #3
    Registered User
    Join Date
    03-09-2010
    Location
    Loughborough
    MS-Off Ver
    2011
    Posts
    19

    Re: Pivot table issues

    Thank you for your help. That has solved the issue for me.

+ 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 issues !
    By ExcelSi100 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 10-31-2016, 05:22 PM
  2. Issues with a pivot table
    By The Pirate Chad in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-09-2015, 11:32 AM
  3. Duplication Issues With Pivot Table
    By xybadog in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-27-2015, 07:25 AM
  4. Pivot table issues
    By Fbtettey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-28-2015, 11:14 PM
  5. Pivot Table Formula Issues
    By omerbaturay in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-17-2014, 01:14 AM
  6. Issues with charting pivot table
    By bogdn in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-03-2013, 09:02 AM
  7. Pivot table macro issues
    By arvin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2009, 02:31 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