Pivot table count results of formula

[dolphintabby]

How can I get the pivot table to count the number of the results of a formula instead of counting the number of formulas in a column of cells? When I created a pivot table it gives me a total count of cells that contain a formula instead of the total number from the formula which is a text.
The result of the formula are names of months. I want to calculate how many approved reports were completed by month. Then, I want to see what percentage of approvals there are to completed reports. Can anyone please help me?

 

[bobhc]

Now come on, give us a chance, we may have many powers that mere mortals of the forum do not possess but an upload of your pivot would really help.....


.

 

[dolphintabby]

Okay it let me this time see attached

 

[dolphintabby]

Now come on, give us a chance, we may have many powers that mere mortals of the forum do not possess but an upload of your pivot would really help.....


.

See attached.

 

[Nebu]

Hi;

Please find the attached. There is no need of month formula to get the count by month , the pivot will do it for you. I am not sure what format you were looking for. I have created two pivot tables by taking a cue from the pivot you already had in the file , if you are looking for something different let us know.

Thanks

 

[dolphintabby]

That is awesome but I also needed it divided across the top where it says FMQR by month I also need it by Type so horizontal access is by type and vertical like you have it by month.

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[dolphintabby]

Hi:

Find the attached.

Thanks

Wow you are awesome! Thank you

 

[dolphintabby]

I tried to figure out how you added month and year to the pivot fields but I haven't been able to figure it out. How did you separate them out?

 

[Nebu]

Hi:
Follow this link.

https://support.office.com/en-au/ar...e-report-059b7571-55a3-4127-8990-0cf0b9b880f7

Thanks