Using Set Analysis to ignore single filter

[DipeshVadgama]

Hi All,

I really appreciate if any one can help me on this.

I have KPIs which counts total Items & also different filters (5 to 6) to drill down further details in a sheet.

Other filters which are like Year, Month, Customer Name, County,  Business, etc... in a same sheet.

My requirement for one of a KPI object is to exclude one filter among all.

Filter which has to excluded is [Text] which have data as "Yes" & "No". In filter i have added formula = IF( Text = "Yes", "Duplicate Items", No Duplicate") As Duplicate Check

And KPI formula is = Count( $ {< [City] -= {'Not Completed'}, [Priority] -= {'Critical'}>} Items_ID).

Now if i change $ to 1 it freeze for all but i just want it exclude [Text] filter only irrespective of any filters is applied by users.

[tomovangel · Accepted solution]

Hi Dipesh, can you try this?

Count( $ {<Text, [City] -= {'Not Completed'}, [Priority] -= {'Critical'}>} Items_ID)

[DipeshVadgama]

Thank you, But it does not work.

[rathore01 · Accepted solution]

use this - 

= Count( $ {< [Text]=,  [City] -= {'Not Completed'}, [Priority] -= {'Critical'}>} Items_ID).

[DipeshVadgama]

Thank you.

It did not worked 1st but when i made this changes it worked perfectly.

I have added formula " IF( Text = "Yes", "Duplicate Items", No Duplicate") As Duplicate Check"  in scrip and then i have replaced it your solution as below.

= Count( $ {< [Duplicate Check]=, [City] -= {'Not Completed'}, [Priority] -= {'Critical'}>} Items_ID).

Thank you again.