help with expression

[everest226]

I have following expression on my table . all i want is to show all the amount by the each see date ,  currently i have to select see date to see the value and it will only show the value of selected date, but i want this to be display all by the see date .

dimension is see date 

Sum({<[Request Type]={'SA'},[ Action]={'APP'},[Dep Date]={">$(=[see Date])"},[T Date]={"<$(=[see Date])"}>}[Amount])
-
Sum({<[Request Type]={'CR'},[ Action ]={'APP'},[ Dep Date]={">$(=[see Date])"},[T Date]={"<$(=[see Date])"}>}[Amount])

[Anil_Babu_Samineni]

For me the expression what you did is quiet wrong, perhaps this? I am just altering your expression to proper syntax

Sum({&lt;[Request Type]={'SA'},[ Action]={'APP'},[Dep Date]={"=[Dep Date]&gt;[see Date]"},[T Date]={"=[T Date]&lt;[see Date]"}&gt;}[Amount])
-
Sum({&lt;[Request Type]={'CR'},[ Action ]={'APP'},
[Dep Date]={"=[Dep Date]&gt;[see Date]"},[T Date]={"=[T Date]&lt;[see Date]"}&gt;}[Amount])

[everest226]

what is &lt; does in this expression . 

[Anil_Babu_Samineni · Accepted solution]

Not sure, why this got changed. I just mentioned <= and >= like below
Sum({<[Request Type]={'SA'},[ Action]={'APP'},[Dep Date]={"=[Dep Date]>[see Date]"},[T Date]={"=[T Date]<[see Date]"}>}[Amount])
-
Sum({<[Request Type]={'CR'},[ Action ]={'APP'},
[Dep Date]={"=[Dep Date]>[see Date]"},[T Date]={"=[T Date]<[see Date]"}>}[Amount])

[everest226]

Thanks @Anil_Babu_Samineni

Its gives the same result. but the value only shows when i click viewdate from listbox where as i am trying to show every viewdate value in table .  is it because VIewDate is independent island in data model  which is not linked to any table?

Thanks

Again

[Anil_Babu_Samineni]

If that table is not associated to any, definitely the only reason is that.