Forum Discussion

Copper Contributor

Apr 08, 2021

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...

excel

SergeiBaklan
Apr 08, 2021
rahulvadhvania

Creating the data table add data to data model

and add measure like

Result will be

average no zero.xlsx76 KB

SergeiBaklan

Diamond Contributor

Apr 08, 2021

rahulvadhvania

Creating the data table add data to data model

and add measure like

Result will be

average no zero.xlsx76 KB

Saron12

Copper Contributor

Feb 24, 2022

SergeiBaklan I couldn't use the formula to exclude the Zero, No option to include the data Model

SergeiBaklan
Diamond Contributor
Feb 25, 2022
Saron12

What is your Excel version and platform?
- Saron12
  Copper Contributor
  Feb 25, 2022
  Office 365 Web
  - SergeiBaklan
    Diamond Contributor
    Feb 25, 2022
    Saron12
    
    You need Windows Desktop version of Excel to create data model.