Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
my master measure calculation is: sum(aggr(ShippedTEU,CntrSeal))
There are multiple filters that get applied(YearWeek_Filter, Carrier_Filter, Region_Filter etc). The requirement is to ignore the selection from the 'Carrier_Filter' so overall shipped teu number is shown even when a carrier is selected (to view carrier specific performance and overall performance side by side).
I've tried the following two but it does not work:
appreciate any help please.
For anyone with similar requirement...
I used 'alternate state'. the filter containing 'carrier_filter' dimension got new alternate state applied. whatever dimension is required to be excluded (in my case, selection from 'carrier_filter to be ignored) needs to have the alternate state applied.
For anyone with similar requirement...
I used 'alternate state'. the filter containing 'carrier_filter' dimension got new alternate state applied. whatever dimension is required to be excluded (in my case, selection from 'carrier_filter to be ignored) needs to have the alternate state applied.