Hi,

I have a pivot table set up to show data in minutes.

Screenshot 2020-06-29 at 10.22.15.png

I already have it set up to show the count of each set of minutes, min, max and average.

I want to add a column that will count all the values in the first column that lay between 0-30 and then I would like a column next to that that would display the % of that range count from the total.

For instance, doing a visual count, I know there are 11 values that lay between the 0-30 range, 11 values represents 61.1% of the total (which is 18). I just cant seem to get these values presented the way I need them.

Many thanks in advance.