S
Sabosis
Hello-
I have about 50 sheets (based on different item codes) with pivot
tables on them that show the customers that ordered the item. The
customer number is in the row field, the month (Jan 2006-Mar 2009) is
in the coulumn field, and the count of items ordered is the data field
on each tab of the speadsheet. I need to evaluate each customers
purchases and see if they ordered over a certain amount in a given set
of months. For instance, to see if customer A ordered more that 15 in
any six month period across the 39 months represented in the month
columns. If so, highlight that 6 month block in a certain color. Any
ideas on how this can be done? Also, not all of the sheets represent
39 months, that is the range for items that had purchase history
starting in 2006, some of the item might have been started in say June
2008 or January 2009. In these instances, I dont want to evaluate
across 39 columns, but 20, or 15, or whatever the pivot table range
is.
Thanks for any help that might be supplied in figuring this out.
I have about 50 sheets (based on different item codes) with pivot
tables on them that show the customers that ordered the item. The
customer number is in the row field, the month (Jan 2006-Mar 2009) is
in the coulumn field, and the count of items ordered is the data field
on each tab of the speadsheet. I need to evaluate each customers
purchases and see if they ordered over a certain amount in a given set
of months. For instance, to see if customer A ordered more that 15 in
any six month period across the 39 months represented in the month
columns. If so, highlight that 6 month block in a certain color. Any
ideas on how this can be done? Also, not all of the sheets represent
39 months, that is the range for items that had purchase history
starting in 2006, some of the item might have been started in say June
2008 or January 2009. In these instances, I dont want to evaluate
across 39 columns, but 20, or 15, or whatever the pivot table range
is.
Thanks for any help that might be supplied in figuring this out.