• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can I write an 'or' statement in a pivot filter?

C

clevine

New Member
Disclaimer: I am a self taught novice....


I am trying to determine in a pivot if there is a true statement in any of five columns on a spreadsheet but when I put all five in the filter box it seems to show the data as an "and" statement rather than an "or" statement. Is there any way to work around or fix this?
 
Jason


An "and" would have forced the OP to give more information than your "or" and it would have been there for all to see or am I wrong
 
i think you're wrong!... but mainly just so i could say that BOBHC was wrong.


either would sufice be more helpful.... both would be ideal of course
 
All this and no answer to Clevine's question

or somehow it was answered and I missed it?!?


@Celvine... Pivot table filters applied on different columns always act as AND.

The easiest way to get what you want is to add a helper column to your source data and use OR formula there like =OR(col1,col2,...,col5)


Then, put this in your pivot report filter and filter for TRUE values.


Another option is to create a calculated field that does the same, but calculated fields are a pain to work with.


Hope that helps.
 
Thanks Chandoo--and you are a 'punny' crew aren't you??


I will try the helper column; have learned so much from you; when are you coming to Atlanta?
 
we like to have fun with one another.... AND (i dont know how to do the fancy Bold formatting) help eachother out!


(i was waiting to learn more about the layout and give my shot at the helper column/pivot setup.
 
Good day jason

Does this help

[pre]
Code: 
Codes used in the post: 

THESE FOR CHANDOO.ORG and CHANDOO.ORG/FORUM POSTS
=================================================

<strong>This is Bold </strong>

<em>This is Italic</em>

<a href="http://Chandoo.org">"A Link to Chandoo.org"</a> !

<blockquote>This is Block Quote text
It displays like
This!
</blockquote>
<ul>This is Underlined</ul>
<ol>This is Indented</ol>
[/pre]
 
Worked Great! .....the bold that is.


I added a helper column with this formula: =IF(OR(AT2<>"",BA2<>""),"yes","no") so that it would tell me if there was a value in column AT2 or BA2 using a discreet 'yes' or 'no' and it worked as well! :)
 
You must log in or register to reply here.
Back
Top