How to remove null values from set, while the set is specially set up to control two sheets I was able to solve my problem to show a calculated field even when the filter filters out the previous value in this question https://community.tableau.com/s/fe...
oLo.DataBodyRange.RemoveDuplicates Array(1, 2) For future consideration: Power Query can accommodate your complex reasoning and produce a filtered table (inside your current workbook or in another workbook) without removing rows from the original table. No VBA required. In the example ...