What's the formula for a percentage of a column field ie., want 5% of a YTD total field

[Joelyn01]

What's the formula for a percentage of a column field ie., I need to calculate 5% of a YTD total field

[#2]

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()