+ Reply to Thread
Results 1 to 5 of 5

Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!

  1. #1
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!

    Hello Pals!!
    I am searching for something which i don't know if its possible or not.
    I want to know if we can display TEXT in Values field in Pivot Table...
    i know its not possible manually but using VBA, is it possible??
    ANyone?? EXPERTS??

  2. #2
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!

    NO ONE??

  3. #3
    Registered User
    Join Date
    02-04-2015
    Location
    Brisbane, Australia
    MS-Off Ver
    2013
    Posts
    6

    Re: Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!

    Hi meus,

    Not sure if I understand what you're saying. So you have text that you want to summarise? What values should be in the value field if there are more than 1 text entry matching the row item?
    <--- Please click the * Add Reputation button

  4. #4
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!

    How can you summarize the text??
    i just meant to display text in values field.. thats it...

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!

    No. Pivot tables require numeric data to be aggregated. They don't use text in the values area.

    However if you're using code, why do you need an actual pivot table?
    Remember what the dormouse said
    Feed your head

+ 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. Replies: 1
    Last Post: 08-10-2014, 01:22 PM
  2. Replies: 0
    Last Post: 10-21-2013, 05:06 PM
  3. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  4. [SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes
    By andreindy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2013, 05:49 PM
  5. Pivot Table "Data Field" for text rows
    By duffeymt in forum Excel General
    Replies: 0
    Last Post: 11-30-2006, 03:35 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