Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have a KPI that updated depending on the filter selected. I have two filters, Building and Week. I need for my KPI NOT to change when a week is selected. I tried a few things like this:
Count({$<Week=>} {<xtype={'Eyewash Station'}>} xtype)
But that doesn't work, any ideas?
Thanks!
Oh, I see what I did wrong!
THANK YOU!!!
What if I do NOT want the total residents in a KPI to change when multiple filters are applied? Because the residents are always the same no matter what filter is applied.
Filters are EXPENSE CATEGORY, TRIAL PHASE, YEAR, drill-down dimension THERAPEUTIC AREA, PRODUCT?
Thanks
try this:
Count( {1< xtype = {'Eyewash Station'} >} xtype )