Forum Discussion
thebeginner1204
Helper I
2 years agocolumn chart dynamic compare 3 periodes with filter
Hello to everyone I need to build a column chart with different organizations in x-axis, the total sales in y-axis and this over three years compare with selected period (year, month, day). Eg. ...
thebeginner1204
Helper I
2 years agoThank you very much for the feedback and the questions.
Dynamically 3 years should be defined with a date filter (see print screen above with selected period).
There the year 2014, month January / February and all days are selected. Calculating the current year is easy with SUM.
But I would also like to calculate the previous periods dynamically according to the filter selection. therefore year 2023, month Jauar / February all selected days.
Does that help?