I have a set of data from which I am trying to create a Pivot Table. The data lists several thousand items and their respective amount of "cases sold" in the last 12 weeks. I am trying to "group" all the items that fall into the 1-5 cases sold range, 6-10 cases sold range, 11-15 cases sold range, etc. Then I would like to do a Pivot Table based on these groupings. And to make it even more complicated, I would LOVE to have the aforementioned ranges be dynamic so I can change them to 1-6, 7-11, 12-15, etc and then refresh my Pivot Table with the new stats. I have used IF/Then statements and it kinda works but I thought I would see if anyone has any better ways. Any suggestions? Thanks in advance!