Andrew131

For example, I have a gallery type page with search and results, I can't filter of by "Hide field if blank" because there is a text value of 'None', so I wanted to hide the result if the value for field C_Add_on1 is 'None'. The table that contains the 'Add-ons' values is quite extensive so searching by the options wanted and exclude 'None' its not really an option. It's set up by C_Add_on1, C_Add_on2, C_Add_on3, up till 5 on the gallery results, but only the first one will have the value 'None' so the others I could use "Hide if blank". Ultimately wanted a way to filter off results if this specific keyword shows in one of the fields.

Hi @BrianI, I'm trying to figure out how to hide results for a specific word. It is a results page so I don't have virtual fields available. If the word 'None' appears as a value for this field, then hide the result. I've tried the above suggestions and others but not working so far.

Thanks @CoopperBackpack. I made it work by keeping only the two datapages I created and passing the date parameters from the chart to the pivot table.

I have a Combined chart & report datapage and a Pivot table. They are set side by side on a single page. But both of them has its individual search function. I'm trying to find a way where I can keep only one search field that will display the results in both elements instead of separate search fields.