+ Reply to Thread
Results 1 to 2 of 2

Text data appears as 0 in my Pivot table - how do I display as tex

  1. 08-09-2005, 02:05 PM #1
    Murray Snedden
    Guest

    Text data appears as 0 in my Pivot table - how do I display as tex


    Reply With QuoteRegister To Reply
  2. 08-09-2005, 03:05 PM #2
    Debra Dalgleish
    Guest

    Re: Text data appears as 0 in my Pivot table - how do I display astex

    You can't display text fields as text in the data area. You could add
    the field to the row area, where the text will be displayed, then use
    another field in the data area to obtain a count of the occurrences.


    Murray Snedden wrote:

    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1