How to make pivot table count the due for revision which pass this month march 2019

[emma1231570]

Hallo there

Would someone help me, why my pivot table didn't work to count the due for revision which supposed to count the expire date.

I am using excel 2010 and want to count due for revision in pivot table. I saw that pivot table count for my data that have "P.9.6.100" zero number not the expire date.

I attach the file here, been working in this for 5 days since.

Thanks in advance

[#2]

Hello Emma

you have to change the field settings individually to the tabular form & also put the "due for revision in the row column of pivot fields

please check the file i did some changes, hope it will help you in solving your problem @emma1231570