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
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)
You may create as many measures as necessary each with different formula and show them in separate columns. If that's what you mean. Or you'd like not to show dates where average is zero?