Creating a Pivot Table Based on a Count Range

kogersdad

New member
Joined
May 2, 2012
Messages
17
Reaction score
0
Points
0
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!
 
I think that is EXACTLY what I needed!! thanks for your help! I have said it before but I will say it again "You are a genius!"
 
Back
Top