I need Pivot Table / Data sort help and appreciate anyone who can assist. I've watched about 25 Youtube videos and cannot find the correct process on how to do this.
I'm a B- with Pivot Tables. I have one created and got a bunch of data I needed but one thing I am stuck with is how to group a range of numbers and then the sum of how MANY of those numbers
Exact need:
- I have list of 12,000 records with a list of states in one column and the number of Units they have in the other
- I want to group by States and THEN have a grouping / filter by the segments below to have a total
- Power Units 50-100
- Power Units 101-250
- Power Units 250-500
- Power Units 500-1000
- Power Units > 1001
The end result would be like this
Alaska
Power Units 50-100
12
Power Units 101-250
6
Power Units 250-500
4
Power Units 500-1000
1
Power Units 1001 0
Alabama
Power Units 50-100
44
Power Units 101-250
12
Power Units 250-500
3
Power Units 500-1000
5
Power Units 1001
2
Can anyone solve my dilemma? 