Justmeok
New Member
Hi Everyone 
I am not very skilled with Power Pivot and I have a pivot table that has a column total for annual budget broken up for different sales reps. The % amount is achieved by using a measure. I am trying to get a measure that replicates the excel formula I have in the attached file. You will see my attempt at getting the measure to work. Failure No 1 (well to be honest I've lost count of the different measures I've tried but suffice to say they have all failed
)
Looking forward to some help please?
I am not very skilled with Power Pivot and I have a pivot table that has a column total for annual budget broken up for different sales reps. The % amount is achieved by using a measure. I am trying to get a measure that replicates the excel formula I have in the attached file. You will see my attempt at getting the measure to work. Failure No 1 (well to be honest I've lost count of the different measures I've tried but suffice to say they have all failed
Looking forward to some help please?