Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula for adding percentages in the Pivot Table

Topic Labels: Base design
532 0
Showing results for 
Search instead for 
Did you mean: 

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!

0 Replies 0