Results 1 to 6 of 6

Unsure if PivotTable is the correct feature

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2013
    Location
    U.S. Army
    MS-Off Ver
    Excel 2007
    Posts
    3

    Unsure if PivotTable is the correct feature

    I'm trying to reorganize the masterlist of all of my supplies so that they show up dynamically under the categories they belong to.

    So that instead of having:

    CAT1 SUBCAT1 ITEM1
    CAT1 SUBCAT1 ITEM2
    CAT1 SUBCAT2 ITEM1
    CAT2 SUBCAT1 ITEM1
    CAT2 SUBCAT2 ITEM1

    I have

    CAT1 SUBCAT1 Item1
    Item2
    CAT1 SUBCAT2 Item1
    etc.

    For the most part PivotTables seem to accurately perform that task, but I don't seem to be utilizing either the column or data fields. This made me think that perhaps it would be better to perform this task with another feature, or that I wasn't fully utilizing the PivotTable abilities. I intend on adding in the QTY of each individual item; however, it seems that doing so creates an undesired column effect.
    Last edited by DocReardon; 06-17-2013 at 09:38 AM.

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