Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want that if I select one value in the List-Box (for example Date) that are show the 10 dates before the value and 20 values after in the chart.
Any idea how i can do that?
Example:
Choosen date ist the 20.01.2012.
The chart shows the sales from 10.01.2012 to 09.02.2012.
Hi,
Use below expression in your chart.
sum({<Date = {">=$(=date(max(Date)-10))<=$(=date(max(Date)+20))"}>}Sales)
Regards,
Kaushik Solanki
Hi,
Use below expression in your chart.
sum({<Date = {">=$(=date(max(Date)-10))<=$(=date(max(Date)+20))"}>}Sales)
Regards,
Kaushik Solanki
Hi,
Please find the attached sample
HTH
Sushil
How must I change the expression if the selection is no date format?