Results 1 to 1 of 1

Is there an OR type filtering available in Pivot

Threaded View

uvaidya Is there an OR type filtering... 11-15-2012, 07:32 AM
  1. #1
    Registered User
    Join Date
    08-10-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    19

    Is there an OR type filtering available in Pivot

    I need help with Pivot charts.
    In a pivot chart, we can add several filters. If there are two, then they only act as AND condition.
    Can we make them as OR filters?
    The below table has 2 columns. Service provided by the bank and the proximity of the bank to the customer location.
    Anything that is rated >=6 is Good. If a bank gets a < 6 rating in one of the criteria needs to be identified.
    How can I easily do this using pivot charts.
    Please help me. I have uploaded my sample excel sheet.
    thanks in advance.

    Bank Service Proximity
    Bank1 5 7
    Bank2 4.5 1
    bank3 6 6
    bank4 7 2
    bank5 6.5 6.5
    bank6 5 5
    bank7 7 3
    bank8 4 6.5
    bank9 6 2
    bank10 3 7
    Attached Files Attached Files
    Last edited by uvaidya; 11-15-2012 at 07:35 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