Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Dipesh, can you try this?
Count( $ {<Text, [City] -= {'Not Completed'}, [Priority] -= {'Critical'}>} Items_ID)
use this -
= Count( $ {< [Text]=, [City] -= {'Not Completed'}, [Priority] -= {'Critical'}>} Items_ID).
Hi Dipesh, can you try this?
Count( $ {<Text, [City] -= {'Not Completed'}, [Priority] -= {'Critical'}>} Items_ID)
Thank you, But it does not work.
use this -
= Count( $ {< [Text]=, [City] -= {'Not Completed'}, [Priority] -= {'Critical'}>} Items_ID).
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.