Hi community, I have an aggregated pivot table as shown and would like display 0% in the percent difference row instead of leaving them blank. I don’t think i can use calculated field cuz the table is aggregated(correct me if I’m wrong). Is there any way that i can show the zeros?
Please take a look at the response for a similar question :Calculating Diff in Pivot Table . Please let us know if this helps.
Hi, @Yufei. We hope Prachi’s solution worked for you. Let us know if this is resolved. (And if it is, we’d love it if you could mark his answer as a “Solution.”) Thanks!
Hi @Yufei. We have not heard back from you regarding your question. We would still like to help. If this is no longer relevant after seven days, we will archive this question.