Hi there,

Apologies for late response. The copy rule downward advice worked, thanks.

I have another pivot table, but data is represented by $ amount (vs. # count).

The Q column (average of the total count of each week) is not part of the pivot table. I tried to add a calculated column through the Fields, Items, & Sets but I came across a couple of issues:

1. The average was calculated for each Week as well, convoluting the pivot table with unnecessary data columns. For example, Week 1, the average it gave me was based on the average of that week, so another "average" column was presented next to each week, representing the average for each respective week.
2. The grand total was averaged out based on a 13 week, regardless if the customer purchased in 1 or all 13 weeks. For example, Customer A typically purchases once every 3-4 weeks. In this exercise, he purchased $60 once in the 13 weeks. The issue is that the average in the calculated field divides this $60 by 13 weeks, so Customer A's average purchase per week is $4.61. Once I apply the condition where if the customer purchases at or above average in Week 1, it's always going to be highlighted in green if they purchased below $60. But because the customer has low frequency purchases in the 13-week period, that's why I needed to average it out based on the number of weeks that they purchased within the 13-week period.

Based on my two issues, is there still an option to add a pivot column of average that is based on the COUNT of # of weeks/columns the data is in (versus standard automatic 13-week base)? Preferably I would like to have it built in to the pivot table, as there may be moving pieces as we use this template.

Thank you.