Hide column if all data is collapsed

#1

I have a table visualization, where I want to default the last hierarchy to be collapsed. In this case, it is specific IDs, so I want the user to have the option of expanding to be able to see the IDs if they want to investigate further.
However, when I have the ID hierarchy set to “collapse all”, the column still shows up with “(All)” in each row. Is there a way to hide that column and only have it appear if the user expands the preceding hierarchy?
A good example of this is the date hierarchy, which adds a column for each level as you drill down from year to quarter to month to day.

Thanks!

#2

Hi Molly,

If it makes sense or works for you, you could make the IDs a second level or higher of an actual hierarchy created from the left menu, which would behave like the date hierarchy you’re describing.