I have a pivot table that I am using to capture daily usage of items. In column A(outside the pivot table) I have a daily average formula that pulls the average of the range. I currently have to adjust the range each day when the pivot table is updated. How can I have the range in the average column auto adjust as new dates are added. Thanks for the help
<tbody>
</tbody>
<tbody> </tbody> |
<tbody>
</tbody>