Formula for adding percentages in the Pivot Table

Hi! I’m trying to get percentages to show in my pivot table but can’t seem to. The way my base works is that the rows are products and several products can be part of one Order Number. I have a field for statuses (Delivered, Shipped, Pending, Booked). What I need to see on my pivot table is the percentage of the order numbers that are Delivered, Shipped, Pending, etc.

I think what I have to start with is create a field with a formula, then use that field for the pivot table column. But I’m not quite sure how to go about the formula field to begin with.

Hope I can get some clarity on this! Thanks!

1 Like

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.