Results 1 to 4 of 4

Excel pivot table? Edit pivot table sub catagory

Threaded View

  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.

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