Re: Creating a list from Variables in Set Analysis
I've attached my report.
My main concern is getting the chart to maintain the colors by expression for the [Summary Business Unit] in the charts.
Whenever I make a selection, it loses the colors, with the exception of when selecting the max month within a quarter.
Each chart in the attached report has a different way of keeping the range of 4 quarters, with the exception of the third one, which uses the value of the fields based on the month selected ([1 Qtr Back],[2 Qtrs Back],[3 Qtrs Back]).
The table represents the quarters that should be used based on the month selected.