Forum Discussion
Average excluding zeros in pivot table
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!
2 Replies
Sorry, I posted it in a wrong forum
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.
