Is there possibly a way for the user to choose what field to investigate in the expression (for my purposes in a pivot table)?
For example, I have a cyclic group with fields, say field1, field2, field3.
In the pivot table, I want to display the null count for each field as I cycle through, but if I make the expression NullCount(field1), I would have to go back into the expressions box and change the inside of the NullCount(____) to field2 or field3 whenever I want to look at the different null counts.
Is there a way to make the expression read something like NullCount(group), where the group cycles through the corresponding fields?
just to mention when you refer to the Group Name as in GetCurrentField(Group1) or NullCount( GetCurrentField( GroupName ) ), the group name will be underlined as if it was a mistake but is just a bug with syntax highlighting, so it should work,
