I’m working on a PTO system. The Admin can add hours (Yearly) and then people can place requests, that start as Pending, and then moved to Denied or Approved.
I’d like to show their available hours for the year (we work on calendar). So I set up a Pivot table, by year, that is supposed to show the Available = Yearly Credit - Pending - Approved. Denied requests are there for reference and are not a component of the balance of hours.
So I set up a Pivot table, and then selected the values I want included. However I’m still getting Denied in the resultant table. This will skew the info presented to team members.
How can I suppress the Denied? I also tried Approved Status *NE to Denied, but that didn’t work either.
