I have records with planned and actual values. For some records only planned values exist.
Some table charts show all records, actual show up as null.
I wanted now to create a table that concentrates on planned-actual differences and should use only records that have an actual value set. I could create an additional selection for "actual only" but this will then impact my other tables too and might confuse the user thinking everything has actual values.
So what I was looking for is a subset of all records with existing actual values for this table chart only.
I could create a separate data table when loading that contains only records containing actual values but this will (almost) double the used memory?