Hi everyone,
I have the following problem:
I have a combochart that keeps the values referring to the current period, the forecast one and the difference of the current one with the following one, for example:
Value Actual 2018, Budget 2018 and Actual 2018-Actual2017.
The chart is a time dimension that can be: month, quarter, half year or year, based on the selection of a variable.
Furthermore, to enhance the numerical fields I am using a set analysis where I entered the dates that have been selected, for example:
I select from 01/01/2018 to 31/12/2018 and then in the set analysis I will have that date must be contained between these values.
Would there be a way to tell him to aggregate considering the previous year?
Thanks,
Livio