changing the dropdown selects in a table to reflect set analysis

[mstoler]

Hello,

Is there a way to have the dropdown selects reflect set analysis.

In this example in my set analysis I am selection Sum({$<Location={'LocationA'}>}Amount) which only contains Item1. 

However in the drop down select I see  Item1 & Item2.  I would like to see just Item1 in the dropdown.

Thanks,

Michael