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
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