+ Reply to Thread
Results 1 to 4 of 4

Excel pivot table? Edit pivot table sub catagory

  1. #1
    Registered User
    Join Date
    09-14-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    16

    Excel pivot table? Edit pivot table sub catagory

    ok this may be a tuff one to explain. Working with a workbook.
    I did not create. Creator is no longer with the company.

    Workbook has a database(worksheet) call masterlog were we enter all leads and their sources(self gen, marketing ,mail, referal, Store 1 , store 2 etc...)

    I see 2 pivot tables(with drop downs) one is "lead source"-its drop down displays the leads mentions above(tech turnover, self gen, marketing ,mail, referal, Store 1 , store 2 etc...)

    The second pivot table has a drop down(Turn over, Retail, Store, BLank)
    Somehow
    Turnover=Tech turnover
    Retail=self ge,marketing,mail,referal)
    Store=store1,store2

    How do I edit the second drop down. I want to add store 3 to the "store"
    Store=store1,store2,store3

    I cannot see anywhere in this workbook how"turnover,Retail and store" were created. I dont see a list tab for these.

    When I look at the drop down for lead source2 it now
    displays


    Turnover
    Retail
    Store
    Store3



    I hope I am explaining this clearly.

    Feel free to ask questions if more detailed info is needed.

    Thanks
    Last edited by Bowtye8; 02-21-2012 at 05:33 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Excel pivot table? Edit pivot table sub catagory

    You may have some hidden worksheets in the workbook. Right click on one of the visible tabs and select Unhide if it's available.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    09-14-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Excel pivot table? Edit pivot table sub catagory

    No joy...I did select all...right click. I see hide but seems nothing to unhide.

  4. #4
    Registered User
    Join Date
    09-14-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Excel pivot table? Edit pivot table sub catagory

    I think I got lucky and figured it out.
    I was able to highlight the three sub topic leads. I right clicked and Grouped. It changed the original topic heading of Store to Group2...I renamed Group2 to "Store" and it seems to have grouped the three subtopics to Store
    It used to look like this

    Store <-Store 1, Store1
    Store3

    Now all are under "Store" <-store1,store2,store3

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1