Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try like this
= Sum({<Year = {">=2000<=2005"}>}Sales)
Hi Ramasamy,
its working fine, thank you.
Hi Viresh,
Find the attached example and look at the following discussions.
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)
thank you!!!
Please close thread by selecting appropriate answer
Please close the thread by selecting Correct Answer.