Filter field data

Question & Answer
, , ,
1

Hi,
I am working on a pivot table that counts days associated with a certain assignment for our pilots.
The categories I have are:

  • Vacation
  • Sick
  • Customer 1
  • Customer 2
  • Customer 3
  • …

With a parameter associated control, I want to be able to select the following:

  • “Vacation”, which will count the vacation days,
  • “Sick”, which will count the sick days,
  • “Per Diem”, which will count all days assigned to customer 1, customer 2 and customer 3.

The first 2 are quite straight forward as “Vacation” and “Sick” are values that are part of the field I am fishing in. This is not the case for “Per Diem”…

How would you work around that ?

Thank you,

2

Hi @hcrochard

From your example, if you have limited number of know parameter list like Vacation/Sick, then try using notIn function, which return Boolean value True/False. Count record with True value.

1 Like