Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Formula for adding percentages in the Pivot Table

Topic Labels: Base design
508 0
cancel
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