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