Forum Discussion
Phantom Filter on Grid
I don't think the issue is hidden filters, i think the issue is the columns in your top grid. There is something about the columns in your top grid that is causes certain records to have "blank" results and are thus hidden. From your screenshot, you can see that the top grid only has 2 filters applied, both are your slicers.
To test my theory, remove every column from the top grid besides Status and Cnt. If you suddenly get the correct numbers, you know its one of the columns that were removed. You can then individually add them back in until the numbers disappear again.
Thanks for you help....
There is a single data set behind all the grids in the screenshot. There are no page filters. As you can see from the lower grid there are several Status Values...REJ, OB, CALC, PREOF with counts indicating there are records with those status values.
But these records do not show in the grid.
I hope I've explained the problem clearly enough.
I don't think the issue is hidden filters, i think the issue is the columns in your top grid. There is something about the columns in your top grid that is causes certain records to have "blank" results and are thus hidden. From your screenshot, you can see that the top grid only has 2 filters applied, both are your slicers.
To test my theory, remove every column from the top grid besides Status and Cnt. If you suddenly get the correct numbers, you know its one of the columns that were removed. You can then individually add them back in until the numbers disappear again.
YOU WERE TO RIGHT!
I had a column that was a Sum of a value that was only on some records. This seems to have caused only records with a value in this field to be shown.
Thank you for your patience.