3 Replies Latest reply: Apr 21, 2015 6:08 AM by Abinesh Sathish

# how to find the sum of total in particular date

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

• ###### Re: how to find the sum of total in particular date

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

• ###### Re: how to find the sum of total in particular date

try:

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

• ###### Re: how to find the sum of total in particular date

Thank you Robert I got the solution from you answer.

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