+ Reply to Thread
Results 1 to 2 of 2

Filtering a pivot table

  1. #1
    Registered User
    Join Date
    11-25-2008
    Location
    Poland
    Posts
    25

    Filtering a pivot table

    Hello, I need help In my attachment I have a table with Mobile Phone Attempts and the Results of Attempts : F(Failed), R(Rejected), S(Succesfull). I need to do something like that :

    For example :
    I filter Pivot table for F(Failed) and I need to qualify all Mobile Models, who has less attempts than 3 (<3) to the category Other with a sum of all Mobile Models with less attempts than 3.

    mobilephones.xls

    Example :
    Failure table
    Nokia 6300 ------- 1
    Nokia 5300 -------- 2

    Result

    Category Other : 1+2

    Maybe there is a way to do it in VBA ? Please help... Its damn complicated and hard, but I hope someone will help me with this.

    Greetings, Adam

  2. #2
    Forum Contributor
    Join Date
    01-23-2006
    Posts
    194
    pls see attached
    Attached Files Attached Files

+ 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