Author Topic: Compare two columns in header filter  (Read 2217 times)

stevejacobsen

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 46
    • View Profile
Compare two columns in header filter
« on: May 19, 2016, 09:12:07 pm »
I'm trying to figure out how to do a comparison between two columns in a header filter. I have a minimum inventory column and an actual inventory column. I need to show all rows where actual inventory is less than the minimum. I'd like to do it in the header filter so then I can select other filters such as Supplier and know what parts I need to order from each supplier.

Can you point me to an example of this?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Compare two columns in header filter
« Reply #1 on: May 23, 2016, 10:49:35 am »
First you need to add a computed column based on dependent columns, then custom filter or an inbuilt filter condition can be applied to that column.

Example: http://paramquery.com/pro/demos/filter_custom