how to find the sum of total in particular date

[#1]

How to find the sum of total in a particular date.

Ex:

Sum of total from 19/04/2014 to 23/05/2015

pls help me friends

[datanibbler]

Hi Abinesh,

you want to find the total of items in a particular daterange? Do you have those ranges as fixed intervals?

If so, you could use the IntervalMatch() function to join every single date to a particular interval -> Then you could just count the items across the dimension >intervals<.

You could also do it dynamically on the GUI - that is a bit more resource-intensive, but possible: The user can select a from_date and a to_date and you count and use a set_expression specifying that the [date] be >= the from_date and <= the to_date.

HTH

[robert_mika · Accepted solution]

try:

sum( {$<StartDate = {“>19/04/2014”}, EndDate = {“<23/05/2015”} >} Sales )

[#4]

Thank you Robert I got the solution from you answer.

=sum({1<[year]={'>25-05-2006<=05-06-2006'}>}[Order Total])

Thia  ia I made from your answer