To my knowledge this would not be possible. By the very nature of filtering, when data is filtered out it can no longer be shown in the view. You can't "show" what has been filtered out.
2 of 2 people found this helpful
Kind of elementary-level workaround, but still working...
Duplicate Data with Union.
(Need to use Excel if you want to try superstore data, instead of TDE.)
Filter out Sheet 2 to avoid duplication.