Hi All

I was wondering whether there is an easy way to do the following:

I have a Pivot Report created from Power Pivot. This report extracts the data from 3 diffrent tables which all have a realtionship built up together. The colunns in the final Pivot are % Sales, % Perfromance and % Refunds.

What I need to do is tho claculate the average of the three columns. I cant create a measure, I was wondering whether there is a formula like GetPivot or anither way from insode the pivot table (creating a field) that I can claculate the average of three scores and then rank them.

Hope this makes sense

Thanks in advance