Forum Discussion
What's the formula for a percentage of a column field ie., want 5% of a YTD total field
What's the formula for a percentage of a column field ie., I need to calculate 5% of a YTD total field
1 Reply
- Should be =0.05*A1 where A1 is the location of the YTD total. If you are specifically referring to a pivot table and don't want absolute reference then you want to use GETPIVOTDATA()
