Forum Discussion
Solved
How to let Pivot Table ignore ZEROs from the data while calculating Average and Average of Average?
Hello, Thank you for your time to review my post. I have a huge database being supported by pivot tables and pivot charts. The field value used is Average. I am trying to find a way that pivo...
SergeiBaklan I couldn't use the formula to exclude the Zero, No option to include the data Model
What is your Excel version and platform?
- Office 365 Web
You need Windows Desktop version of Excel to create data model.
SergeiBaklan
Is there a way to do this for just a specific column of a pivot table? I have a table with 14 columns but I only need 2 of the columns to calculate a zero omitted avg. The column is being calculated with an IF formula in my raw data. I have attached a screen shot of both my raw data calculation for that column and the Pivot Column (had to black out somethings for privacy)
