Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a counter on my dashboard and list of filters, basically I want the counter to ignore certain filters when user clicks on it, is this possible?
count({$<[Type]={'OPEN'}>} DISTINCT [SalesNo])
I did try changing th $ to a 1 but it ignores all filter selections.
Thanks
Ivan
Hi,
I had same doubt...
You can use like this
Sum({$<Year={$(=Only(Year)-1)},Month=>} VentasNetas)
Where I ignore a dimension Month....
Yes. To ignore a certain fields selection, put it in your Set Analysis without a Set Modifier. Like:
count({$<[Type]={'OPEN'}, [IgnoreThis]=>} DISTINCT [SalesNo])
You can keep the dollar sign, because you want to respect the other selections.