Hi,
I am trying to pass Action of “Region” from one sheet to another Sheet which I am not able to do it.
The Region Dimension is not available on Viz or in Detail and as per requirement we can’t have it there.
So, How Can I pass Region Action from 1st Sheet to 2nd Sheet where
- Region filter should have “ALL” and Multiple selection
- Region can’t be in Row or Column
- Region Can’t be in Details
1 answer
The Dimension must be "in the view" of the source in order to be used as an Action. You'll likely need to find a way to work around that -- why is it that you cannot place it on Detail or use it somewhere in the Source? A packaged workbook example using mocked up data would be ideal. Cheers!