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
Bookmarks