I have following data that shows distribution of fruits on each date.
I want to achieve the following format via Pivot Table, that shows percentage of Apple on each day and show the average at the end as grand total.
I saw a method in AI, to use helper column that add flags to rows of Apple. But still wasn't able to achieve it.
below are the steps that worked for me-
below is an image of what i have done.