Forum Discussion
Averages in a Pivot Table
I created a pivot table to summarize all activities a user performs each day. The source worksheet has multiple rows by user name and the date they worked (user rows are not contiguous). I now n...
Hi Vicki,
Creating the pivot table be sure it's added to data model. You may add measure to it like
=COUNT([Name])/DISTINCTCOUNT(Table1[Date])
which gives the average per day in the period number of records