excelpivotdistributionpercentage

How to find average per day using pivot table?


I have following data that shows distribution of fruits on each date.

Fruit distribution

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.

Apple distribution

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.


Solution

  • below are the steps that worked for me-

    1. Select the data
    2. insert pivot table
    3. put Date in the rows
    4. fruits in the column
    5. Count of Fruit in Values
    6. in 'Value field settings', in show values as select % of Row total.

    below is an image of what i have done.

    below is an image of what i have done.