Hi all
I have the following expression in the table along with some dimensions
sum(
{<
[Quota.VALIDFROM]={">=$(=MonthStart(date(min([Cost_RLP.CalMonth_New]))))"}
,
[Quota.VALIDTO]={"<=$(=MonthEnd(date(Max([Cost_RLP.CalMonth_New]))))"}
>}
[Quota./BIC/K_QUOTE] )
The above expression is giving the output
but if i click one of the dimension in the table ,the table show zero values.
before selection
![beforeselection.PNG](/legacyfs/online/177301_beforeselection.PNG)
After Selection for Code the value becomes zero.
![After selection filter.PNG](/legacyfs/online/177303_After selection filter.PNG)
![After selection.PNG](/legacyfs/online/177302_After selection.PNG)
Can anyone help me in this.
thanks in advance![](/legacyfs/online/emoticons/happy.png)