Hi SAS Community Is it possible to create a filter on a line graph to change the measure that is used in the graph? For example: I want the user to change the measure in the graph from Sales Rand to Sales Quantity. Thanks
... View more
I managed to do this with the calculated item below: IF ( ( Month('DATE X'n) = Month(DatePart(Now())) ) AND ( Year('DATE X'n) = Year(DatePart(Now()))-1 )) DayOfMonth('DATE X'n) <= DayOfMonth(DatePart(Now())) ) ) RETURN 'VAUE X'n ELSE 0
... View more
Hi I tried the above but it does the same calculation for every year in the data. I want it to only return that value for the one month. (Last year, this month)
... View more
Hi, How to calculate the month to date period for the same period last year. Eg. If today is 13/05/2021 (Current Month to Date) how do I calculate what sales was for 1/05/2020 to 13/05/2020?
... View more
