Hey Manish,
I wrote some simple code to present this date, probably an easier way to do it but this works.
For every cell there is an if formula that makes a 1 if the cell contains done, and 0 if there is anything else
(you might want to apply data validation to ensure a typo doesn't cause any errors in this data)
then the formula divides the total number of 1s by 11 to represent the % per SKU and per activity.
This is easily represented in a bar chart although you might want to represent it differently.
Let me know if you have any questions, I've attached an example below. Please mark this thread as solved if this solved your issue.
Bookmarks