Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Exclude This Week / Exclude Today selectors should not effect

Hi.

I have a requirement like for e.g. when i select the YTD selector from Timeperiod Slicer and Excl Today from Exclude Slicer

YTD with Exclude Today selector:

and when i switch from YTD to any of these selectors (Yest,LW,LM,LQ,Today,MAT,Comp,Cust ) for e.g. LW not clearing the Exclude Today selector i am seeing the data '0' in the Matrix Visual. 

LW with Exclude Today selectors:

The requirement is when we switch to LW or any of these selectors (Yest,LW,LM,LQ,Today,MAT,Comp,Cust ) with out clearing the Excl Today/Excl This Week it shoudl not effect the data it has to show the data.

when u look at the below snip i have cleared the Exclude Today option i could see the data. 

similiarly i should see the data even when the exclude today/Exclude This week selectors is selected it should not effect the data. for these Selectors(Yest,LW,LM,LQ,Today,MAT,Comp,Cust ).

 

i have a calculated Measure for Exclude Slicer 

i have a measure but i cant paste it here due to limited chars