how to calculate a sum of sales between two dates?

[#1]

hi i've a problem i need to calculate a sum of sales , for example from december 15th 2008 to january 15th 2009, i can calculted if it's in the same year, but when it's another year , i can't. On the other hand, i need to calculate same sales but in the past year, for example, if i stay in december 15th 2008, i need to calculate the sum of sales to december 15th 2007.

please can you help me?

thanks a lot.

[#2]

Need more information...Maybe you could attach a .qvw?

How are the dates chosen?...from a list box...in an input box...

There are many approaches you can take here. Which one you ultimately choose to go with depends on how the dates are chosen/used. Options include:

Sum(If( ... AND...,)) Statements

Set analysis

Flags on load scripts (ie, if you always want to compare last week to last week last year you could use a binary flag to identify the appropriate date ranges)

sjprows

[#3]

You can use Set Analysis, checkout the Set Analysis dashboard off this website for examples....

[#4]

Hi first to all thanks for the anwers, well the date can be chosen separately by year, month and day (Tha's important), the other way to chose it's through monthname or the totaly date (1/1/2009). i'm thinkig doing to bookmarks and set analysis, but set analysis only allow show informatin if it's selected, and i need information for a year that is not selected, eg: i selected year:2008 and 2009 , month:december, january, day: 15-31 december, 1-15 january. i've the data of january of 2008 but i don't have, by set analysis, the information about december 2007, how i can get that information?

thanks