How to compare 2 fields and their percentage in a single pivot table and chart?

This proposal employs the data model which should be included in the 2021 version of Excel.
After the Table2 is loaded to the data model five measures are added
1. Count of Lot Number:=COUNTA([Lot Number])
2. Count of Incident Number:=COUNTA([Incident Number])
3. Percent of Incidents:=[Count of Incident Number]/[Count of Lot Number]
4. Sum of Pack Qty:=SUM([Pack Qty])
5. Percent of Pack Qty:=[Count of Incident Number]/[Sum of Pack Qty]
The measures are then used in the Values area of the respective pivot tables (Packs and Lots)
Note that to see the chart for the month instead of by the day select the collapse (-) button in cell B4.
Let us know if you have any questions.

To do useful analysis I feel that you will need to restructure the data in Table2 into records similar to what is modeled on the Data sheet.
To be honest I am not sure that I can produce the kind of pivot table and chart that you want from this new version of Table2, however I don't see a path forward using the original setup.
Let us know what you decide or if you have any questions.

Hi JeteMc,

Can you help in creating 2 different pivot tables instead of 1. In attached sheet, i have separated 2 tables containing No. of Incidents and No. of Lot. Now i require a column in pivot table which shall show % for No. of Incidents / No. of lots in a month. I tried but it takes total and shows 88.03% for all months. (Since I require 100-%, so value is 88 instead of 12)

In next sheet i want No. of Incidents and Sum. of Pack Qty. I again require a column in pivot table which shall show % for No. of Incidents / Sum of pack qty in a month. Also, i see that the grand total for pack qty shows as incorrect. Not sure where i am going wrong.

Can you please help?

See if what is on the Pack vs. Incident sheet is what you want.
If so I'll work on the Batch vs. Incident sheet later providing someone else has not already done so before then.
Let us know if you have any questions.

The Grand Total for Pack Quantity agrees with the amount on the Table 1 sheet when Table 1 is filtered to show only Type "Incident": 42,329,611
Please tell us what the grand total for Pack Quantity should be or at least why you think that it is not correct.
The source table for the data model tab DataTable 1 and the pivot table on the Batch vs. Incident sheet is not available.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.