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.
Bookmarks