Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter by one column or another

Hi,   I am trying to add a page level filter to my report which is supposed to filter the page by one of two (or both) columns, Documents[StatusID] and Cases[CaseCompletionDate].    I want the fi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

https://drive.google.com/open?id=1rHWNCVShe0KFpQddWJwajtbeBFNoT9-X

 

Hi mussaenda,


I have attached a link to a cut down version of my report. Currently, the 2 page level filters (Case Completion Date = is not blank & Posting Status ID = 6) are the 2 filters I want to be included in an OR filter.

 

I have made a calculated column, Documents[CompletedOrPostedFilterCol], which ideally would show 1 when either Case Completion Date = is not blank or when Posting Status ID = 6, but currently it shows 1 for every single value and I know that shouldn't be the case.

 

Thanks for your reply!