Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula for adding percentages in the Pivot Table

Topic Labels: Base design
535 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