Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have 4 sheets developed.
In sheet 1. we have developed the Heatmap and Only Year field has to work on the heatmap and even the year, it should work accross the dashboard.
To the year Filter we have Enabled in such a way that only one value can be selected by the user.
In sheet 2, sheet 3 and sheet 4.
we have almost 20 + filters and it shouldn't work on the Heatmap sheet(Page 1)
Can anyone help me on this Please
Option 1 ) Apply the Year Filter via a button Action
Allow user to filter Year values from a Variable then Add 4 Actions One for each State to apply the Year filter on
Option2) Apply Set Analysis on All Measures via a filter that consider Year value selected in the default state
Option1 is the simplest and fastest way to get this done
Option 1 ) Apply the Year Filter via a button Action
Allow user to filter Year values from a Variable then Add 4 Actions One for each State to apply the Year filter on
Option2) Apply Set Analysis on All Measures via a filter that consider Year value selected in the default state
Option1 is the simplest and fastest way to get this done