Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table on a sheet that contains a field called PANEL_ID. However, there are other charts in the same sheet and a few buttons I have that filter the sheet for a range of PANEL_IDS. I want to disable that selection from affection my table that has a column for PANEL_ID. for example, the range of panel_IDS is from 1 to 10 and each button makes a selection for the sheet for each PANEL_ID. If i select a button for PANEL_ID 2 I want the selection to affect the entire sheet except for this one table that will still show PANEL_IDS 1-10.
There are a couple of ways to manage selections and what they apply to.
Namely Alternate States and Set Analysis.
The default scenario is that selections apply globally throughout the app.
To create another alternate selection state you can create it in the Master Items and then apply it to your table. This means that the selections made through out the app are not in the same selection state so will not change your table.
Set Analysis is where your expression/measure defines the scope of your aggregation including what selections will apply, so using a measure with Set Analysis in a table allows you to control that.
Hope this makes some sense.
Hello,
Everything is very open with a clear description of the issues. It was truly informative. Your response is very helpful. Many thanks for sharing!
Hello,
Maybe you can ignore the selection of PANEL_ID in specific tables/graphs.
i.e Sum({<PANEL_ID = >}Sales).
Using above syntax, PANEL_ID will not affect the expression and will still show data for all the PANEL_IDs.
Thanks,
Ashutosh