Hi Rafi

You will need to add helper columns to your source data.

See attachment for an example.

BTW I believe you mixed up the fields in your Pivot Table example.

Hope this helps.

Sunny

Dear Sunnykow,

Sorry for very late reply. I thought i won't get reply for my query, so i left from this page. Today (30.01.2020) only i saw your message. Really happy.

Thanks a lot for your time and workings. This really helps me.

Regards,

Rafi

Hi Rafi

Thanks for your feedback.

Better late than never

Hi Sunnykow,

Check the attached the screenshot. Pivot table calculated field, for percentage by default it is taking based on Sum.

Is there any option to change the calculated fields for percentage based on count??

Hi Rafi

Don't understand your question. What are you trying to count?

Can you attach your file with the expected result and what/how you intend to count?