Show/hide items in graph based on page selector
Hi Anaplan Community,
I am working on a management report in which I want to show a graph with actuals and another one with forecast values. Depending on the selected period in the page selector (a list of periods), I want to show certain periods in the graphs.
Example: If the period P05 is selected as page selector, my graphs with actuals should show me the actuals for the past period, the current period and any past period which is a quarter end period (like P03, P06, P09 and P12). In this case, my graph with actuals should show only actuals for period P03, P04 and P05.
My graph with forecast values should show, depending on the same period selected in the page selector, the forecast for the current period, the next period and all future periods which are quarter end periods. So in this case, P05, P06, P09 and P12.
I managed to create this kind of filter logic based on a line item where a period is selected which is driving the calculations. On a normal dashboard I would publish that line item as a field card and I would sync the page selector with that field to get the filtering logic working.
However, in a page/slide of a management report, I don't have the option of a field card. How do I make sure that the selected period in the page selector can drive the filtering logic? Ideally I would like to get rid of the line item that is currently driving the logic.
Anyone with a good suggestion?
See attached for screenshots of what I already have.