5 Replies Latest reply on Oct 16, 2018 9:11 PM by amar savale

# Filtering by grouped and overlapping values

I am trying to create a filter that allows me to select which students do poorly on a test by a calculated field. I have attached a sample workbook because I am unable to post the real data.

In this workbook, we have a calculated field that shows when students score in the "Lowest", "Low", or "Normal" categories. I would like to have a filter that just has the two options:

-Poor test scores (Low & Lowest)

-All test scores (Low, Lowest, Normal)

How can I accomplish this?

• ###### 1. Re: Filtering by grouped and overlapping values

hi see the attached

you can create a set and exclude the highest rank from the set then place the set on the filter shelf

it will return this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: Filtering by grouped and overlapping values

I would create a parameter

Then create a calcualted field like below

Then bring this field on filter self and fiter is for TRUE.

if [Test Score] = 'Poor test scores' then

if [Low Difficulty] <> '3' then TRUE

else FALSE END

ELSE TRUE

END

• ###### 3. Re: Filtering by grouped and overlapping values

It looks like you are creating the parameter "Test Score" which uses the values in "All test scores" - but how is that parameter created with those values before the calculated field is made? Can you attach a workbook so I can take a look at the parameter/calculated fields?

• ###### 4. Re: Filtering by grouped and overlapping values

I am trying to toggle between the Low test scores (shown in your screenshot) and all test scores (including high). I have gotten to creating a set for the low scores, but I am not sure how to combine this with all scores to create one single filter.

• ###### 5. Re: Filtering by grouped and overlapping values

Hi,

Please find the attachment below and mark as Correct or Helpful for you.

(Refer Sheet2 for Solution)

Thanks,

Amar D. Savale