xcelljunkie
New Member
- Joined
- Feb 27, 2013
- Messages
- 10
Hello MrExcel World,
I'm trying to solve a problem that has peeved me for years. I have searched everywhere for a solution with no luck. What I am trying to do is create a pivot table that bands column values when I have multiple fields as Columns. (See the image below) Right now It works because I have the banding set to 3 columns and have 3 months included, but if I pull additional months into the pivot table, the banding doesn't match the grouping of the values.
Any thoughts?
I'm trying to solve a problem that has peeved me for years. I have searched everywhere for a solution with no luck. What I am trying to do is create a pivot table that bands column values when I have multiple fields as Columns. (See the image below) Right now It works because I have the banding set to 3 columns and have 3 months included, but if I pull additional months into the pivot table, the banding doesn't match the grouping of the values.
Any thoughts?
