Sum of Sales for current selection with Max Date

[#1]

using set analysis how can i get total sale

i want sum of sales of max date

but if i select any year then it return sum of sale of that year of max date.

if i select any month then it return sales of max date for that month

[#2]

Use 1 instead of $ in set analysis

[#3]

plz suggest me full expression

[er_mohit]

Try this

sum({<Date={'<=$(=max(Date)'}>} Sale)

[#5]

not working

[#6]

Sum({<Date= {$(=max(Date))} >} Value)

[tresesco]

sum({<Date={'=$(=max({1}Date))'}>} Sale)

Update: for only max date no need of '<' sign.

[ashfaq_haseeb]

Hi,

Try below

sum({<Date={'=$(=max(Date)'}>} Sale)

Regards

ASHFAQ

[#9]

i think first i have to create a variable that store max date for current selection

after that use that variable in expression.

but how to do that i don't know.

[ashfaq_haseeb]

Hi,

Did you try my solution?

Regards

ASHFAQ