Hi That worked thanks. When the calculated item has been put into the list or crosstab I found that you needed to select 'average' as the aggregation for it to do the correct calculation. When I created it as a new aggregated measure instead then it automatically set it as the correct calculation. I had to remember to change the format to percentage too. Thanks
... View more
