Column based filtering how to select it. Please guide.

[ankur10]

How to put/create column based filter. Please guide.

Requesting you to please have a look at the screen shot and tell me how to filter it based on the coloumn

Thank you,
Ankur

[ankur10]

Also I'm not sure how to create a filter based on these conditions.

Please guide.

Thank you,
Ankur

[MFGF]

How to put/create column based filter. Please guide.

Requesting you to please have a look at the screen shot and tell me how to filter it based on the coloumn

Thank you,
Ankur

Hi,

Your filter would be two expressions either side of an OR

eg

([your Scheduled End date] between 2017-04-01 and 2017-06-30 AND [your Status item] = 'Completed') OR ([your Start Date] <= 2017-06-30 AND [your Status item] in ('Active', 'Extension'))

MF.

[ankur10]

I'm not sure how to make a filter for both of these filters. I tried global filter but that doesnt work. As it filters only one condition. Please guide me how to do it.

Scheduled End Between 4/1/2017 to 6/30/2017 Status =Completed

Start Date <= june 30 Status= Active & Extension

Thank You.

[BigChris]

Which part of MFGF's reply don't you understand? Does splitting the filter statement into two lines make it easier for you?

Code Select Expand

([your Scheduled End date] between 2017-04-01 and 2017-06-30 AND [your Status item] = 'Completed')
OR
([your Start Date] <= 2017-06-30 AND [your Status item] in ('Active', 'Extension'))

[ankur10]

Thank you for the reply. I'm sorry to ask that again. My understanding is that "OR" function will give me results by comparing any one of these filters. However I want the data for both of the filters also both of the filters will show add different results. Sorry for being trouble. Thank you for the help.

Please guide me.

[MFGF]

Thank you for the reply. I'm sorry to ask that again. My understanding is that "OR" function will give me results by comparing any one of these filters. However I want the data for both of the filters also both of the filters will show add different results. Sorry for being trouble. Thank you for the help.

Please guide me.

Hi,

Can you be clear on the requirement here? Is it that you want to see rows of data where either one of the above conditions is true, or do you want to see rows of data where both conditions are true for a row? If the latter, simply replace the OR with an AND...

MF.

[BigChris]

Replacing the OR with an AND won't work, because you won't get any records where

Code Select Expand


[your Status item] = 'Completed'
AND
[your Status item] in ('Active', 'Extension')
You'll need to be more specific about what you want it MFGF's filter doesn't give you the right results.

[MFGF]

Replacing the OR with an AND won't work, because you won't get any records where

Code Select Expand


[your Status item] = 'Completed'
AND
[your Status item] in ('Active', 'Extension')
You'll need to be more specific about what you want it MFGF's filter doesn't give you the right results.

Ah! Good catch Chris!

Ankur can you explain what the exact requirement is?

MF.

[ankur10]

Thank you for the reply.

I want that it should filter the values for this time frame-  Scheduled End Between 4/1/2017 to 6/30/2017 Status =Completed

and for this time frame it should filter the values and show in the same column-  Start Date <= june 30 Status= Active & Extension

Thank you,
Ankur

[BigChris]

In that case MFGF's filter will work for you just fine.