Hey, I'm trying to create a Leave management application. But got stuck in between and need some assistance.
As you can see in the first Screen Shot below there are 2 employees as of now and their leave request in the status column is either Approved/pending/Denied.
Now, I want to calculate only the approved leaves per employee and autofill it in the "Availed" column in the "Count" table, as shown in the screenshot below. I'm already using a filter but it counts all the approved text from the 'status" column.
Let's say, if emp1 has got 3 approved leaves then in the "availed" column it should show 3 leaves for Emp1 and then the "Balance column" should show the balanced leaves accordingly.
I've scratched my head for hours but couldn't figure how it should be done.
Any help would be much much appreciated, Thank You!!!
And, below is the summary page in which the data should be automatically filled in the "Availed" section.