I have a dimension which has 3 values in it - "UK", "USA", "Other"
I want to have a trellis report for each dimension but to have each report on a separate tab related to the Dimension.
Is there a filter that can be automatically applied to a Tab so that it only shows data related to one Dimension - I do not want the users to have to select the value from the Dimension.
Two approaches I'm thinking of. First, you could use set analysis to override the user selection in that field for that particular report on that tab. Something like this on the UK tab:
sum({<Country={'UK'}>} Sales)
Second, you could actually select the value when they go to the tab. In the sheet properties, Triggers tab, OnActivateSheet, add an action to make a selection in field Country, search string UK.
Two approaches I'm thinking of. First, you could use set analysis to override the user selection in that field for that particular report on that tab. Something like this on the UK tab:
sum({<Country={'UK'}>} Sales)
Second, you could actually select the value when they go to the tab. In the sheet properties, Triggers tab, OnActivateSheet, add an action to make a selection in field Country, search string UK.
