Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am looking to exclude a table from filters applied elsewhere on the sheet. The goal here is to have two tables, one above the other. The table on top will show filtered results and the table below will show unfiltered results, but the bottom table will only show results when there is a selection made in the top table.
The scenario I am trying to solve is one in which the top table shows a list of Call_IDs with a few columns of details such as date and type. This top table is filtered to only show the results of one team within a larger organization. Call_IDs can span across multiple interactions so there may be other employees on other teams that have the same Call_ID. When a Call_ID is selected in the top table, I would like the bottom table to show all results for that Call_ID, regardless of the filters applied to the sheet/ top table.
Thanks in advance,
If your measure is e.g. Count(Call_ID), the unfiltered measure would be Count({1} Call_ID). You could add a calculation condition to the second table along the lines of Len(GetCurrentSelections())>0 to only have it display data when at least one selection is made.
Alternatively (no pun intended) you could use an alternate state for the bottom table.
So long as at least one measure exists, and you include the set (and suppress zero/null values), this should work. If your object is entirely made of dimensions you would need to add a measure for this to work. However, the alternate state approach should work in both cases.
If your measure is e.g. Count(Call_ID), the unfiltered measure would be Count({1} Call_ID). You could add a calculation condition to the second table along the lines of Len(GetCurrentSelections())>0 to only have it display data when at least one selection is made.
Alternatively (no pun intended) you could use an alternate state for the bottom table.
Thank you, Or.
Would it make a difference that Call_ID is a dimension?
So long as at least one measure exists, and you include the set (and suppress zero/null values), this should work. If your object is entirely made of dimensions you would need to add a measure for this to work. However, the alternate state approach should work in both cases.
Ok, excellent. That helped! The bottom table is now only showing results when a selection is made from the table above. As far as excluding the bottom table from any filters, that would be an alternative state?
Either an alternate state or the {1} in the measure.