8 Replies Latest reply: Jul 15, 2015 9:10 AM by arjun rao

# Question on set analysis

Hi Guys,

I have a bar chart with year as dimension and sales as expression. The year column contains the value form 2000 to 2010.

Suppose i want to see the informatin between 2000 and 2005. can you please let me know how to use between operator.

Regards,

Viresh

• ###### Re: Question on set analysis

Hi

Try like this

= Sum({<Year = {">=2000<=2005"}>}Sales)

• ###### Re: Question on set analysis

SUM({<Year = {">=2000<=2005"}>}Sales)

If you want Last 5 years from today

SUM({<Year = {">=\$(=Year(Today())-4)<=\$(=Year(Today()))"}>}Sales)

If you want Last 5 years from Selected Year

SUM({<Year = {">=\$(=Max(Year)-4)<=\$(=Max(Year))"}>}Sales)

If you want that any other selection i.e. Month, Quarter, Date should not affect your end result, you need to bypass them as below

SUM({<Date=, Week=, Month=, Quarter=, Year = {">=2000<=2005"}>}Sales)

• ###### Re: Question on set analysis

thank you!!!

• ###### Re: Question on set analysis

Please close thread by selecting appropriate answer