Hello,
I've sorted my data in a pivot table to reflect serial#'s in the row section, counting the number of orders opened against each serial#. I want to group the serial#'s based on total count. I need to find a solution to automatically group this on the pivot table. Excel allows you to group dates based on intervals but thats about it. Right now, I have to copy and paste the data to a new worksheet, then create another pivot table to group them. This method returns the values I need but not very practical since its being used in a refreshable sheet with parameters linked to the data source.
Any help is much appreciated. I have very little experience with VBA.
For Example:
Serial# ---- Count:# of orders opened against each serial.
a : 1
b : 2
c : 1
d : 3
e : 4
Result: (2nd Pivot Table)
Count ---- Serial #'s that falls into each category of count.
1 : 2 (a,c)
2 : 1 (b)
3 : 1 (d)
4 : 1 (e)
I've sorted my data in a pivot table to reflect serial#'s in the row section, counting the number of orders opened against each serial#. I want to group the serial#'s based on total count. I need to find a solution to automatically group this on the pivot table. Excel allows you to group dates based on intervals but thats about it. Right now, I have to copy and paste the data to a new worksheet, then create another pivot table to group them. This method returns the values I need but not very practical since its being used in a refreshable sheet with parameters linked to the data source.
Any help is much appreciated. I have very little experience with VBA.
For Example:
Serial# ---- Count:# of orders opened against each serial.
a : 1
b : 2
c : 1
d : 3
e : 4
Result: (2nd Pivot Table)
Count ---- Serial #'s that falls into each category of count.
1 : 2 (a,c)
2 : 1 (b)
3 : 1 (d)
4 : 1 (e)
Last edited:
