Results 1 to 3 of 3

Text to been shown in Pivot table

Threaded View

Ms. Excel Text to been shown in Pivot... 10-14-2016, 12:52 AM
dflak Re: Text to been shown in... 10-20-2016, 09:37 AM
surfinlakkie Re: Text to been shown in... 10-27-2016, 09:42 AM
  1. #1
    Registered User
    Join Date
    01-13-2016
    Location
    malaysia
    MS-Off Ver
    2010
    Posts
    1

    Text to been shown in Pivot table

    Hi,

    Can someone help me with this ?

    This is my Data

    Name Date Team Attn Log In Time Log Out Time Calls Answered
    A 1/10/2016 Business Dev EL 9:26:30 AM 7:05:31 PM 33 0:05:16 2
    B 1/10/2016 TL/ Specialist PH
    C 1/10/2016 Business Dev 9:20:29 AM 7:01:10 PM 35 0:07:04 14
    A 2/10/2016 Support Services Late 9:28:37 AM 7:02:25 PM 13 0:06:32 4
    B 2/10/2016 Business Dev PH
    C 2/10/2016 Customer Service OFF 9:19:23 AM 7:02:39 PM 49 0:05:19 11
    A 3/10/2016 Customer Service EL 9:27:16 AM 7:11:19 PM 51 0:04:10 30
    B 3/10/2016 TL/ Specialist PH


    When i create a pivot table the (Attn) will be in count, I would want the same thing to appear in pivot as well. Is there option ?

    This is for my call center monthly report. i have attached the file as well.

    Thank you very much.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table - formatting data shown
    By maitehar in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-23-2015, 12:02 PM
  2. access pivot table chart with multiple Ranges shown
    By superchew in forum Access Tables & Databases
    Replies: 1
    Last Post: 09-29-2014, 12:48 AM
  3. [SOLVED] remove the blank row shown in pivot table
    By markDuffy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-13-2013, 03:45 PM
  4. Replies: 2
    Last Post: 04-14-2011, 09:33 AM
  5. Column of Text Shown = Total Times Shown?
    By philcassell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-19-2006, 02:25 AM
  6. Pivot table - how to get two data fields shown in two columns
    By Seamus O'Connell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2006, 09:35 AM
  7. why is the data row in pivot table incompletely shown?
    By buumoon in forum Excel General
    Replies: 1
    Last Post: 02-06-2006, 05:10 AM

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