I have a straight table that reports Dim1, Dim2 and Dim3 with Expression1. All of these are just fields. When making a selection in a list box, this table shows records that have that list box value.
What I want to do is report the same Dim1, Dim2 and Dim3 with Expression1 but display records that do not have that list box value.
I can get a list box of Dim2 by using this expression:
MaxString({1-$<[Dim2]={'*'}>} [Dim2])
My problem is that when I add Dim1 and Dim3, they are null values. These are the same Dimensions as original straight table, but when I apply the MaxString expression, all the dimensions return a Null Value.
Any ideas on how I can show the excluded values and have the same dimensions?
