Average excluding zeros in pivot table

[shirinshon]

Hello,

I have a pivot table which shows price of each item we bought in 2024. 

When I drill in to the first item (S400-0125-001), it has several lines and the column Average of Mar 24 Price (above screenshot) calculates the average price including 0.

What are my steps to excude 0 values from calculating the Average price for each item?

Thank you!

[v-fenling-msft]

Hi, @shirinshon 

Please start a new discussion via the Office Community so that you can get dedicated support on this issue:

Results in Microsoft 365 and Office - Microsoft Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shirinshon]

Sorry, I posted it in a wrong forum