« previous next »
Pages: [1]

Author Topic: Multiple filter in pivot  (Read 2200 times)

resolvecomputing

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 40
    • View Profile
Multiple filter in pivot
« on: April 20, 2018, 12:21:08 pm »
Can I make filter for multiple columns in pivot?
Logged

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Multiple filter in pivot
« Reply #1 on: April 20, 2018, 03:13:36 pm »
In case of pivot, multiple filtering can be done on primary columns only ( columns which are present in group rows pane ).

For example in this demo https://paramquery.com/pro/demos/pivot, only country column ( which is present in group rows ) can be filtered.
Logged

resolvecomputing

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 40
    • View Profile
Re: Multiple filter in pivot
« Reply #2 on: April 24, 2018, 12:38:01 pm »
Do paramquery have change event in pgSelect?
Logged

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Multiple filter in pivot
« Reply #3 on: April 24, 2018, 11:48:51 pm »
Yes there is change event in pqSelect which is used here:

https://paramquery.com/pro/demos/showhide_columns
Logged
Pages: [1]
« previous next »