Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I am trying to average the amount of time (Column Q) if there is a 1 in column AA by day.
If I use formulas to review the data (table on the left) I get an accurate average min / LC. If I use a pivot table (on the right) I get incorrect averages (i.e. an average time when no LC occurred).
How do I get the pivot table to give the correct averages without using PowerPivot or VBA?
Required, but never shown
12 days ago