Notifications
Clear all
Xtreme Pivot Tables
2
Posts
2
Users
0
Reactions
196
Views
Topic starter
How can I add an average if function to only return avg values if greater than 0 or not equal N/A in a pivot? Do I need to add a calculated field or can I do this by selecting label filters "does not equal" N/A?
THank you.
Posted : 23/05/2017 2:18 pm
Hi Melvis,
Easy, place your values field in both the 'Values' area and the 'Filters' area of the PivotTable. In the filter remove all zero and N/A values. Then select any cell in the PivotTable values column > right-click > Summarize Values By > Average.
Kind regards,
Mynda
Posted : 23/05/2017 7:55 pm
