I am developing a report in Report Builder 3.0
Thus far I have a matrix which uses Service_Locality, Instance and ActiveStatus as row fields and User_Status as a column field, with UserKey as my count.
Now when the report is run, User_Status splits out as expected into 4 columns - Deleted, Active_HCP, Active_User, Dummy.
What I now want to do is add an indicator column which is based on the percentage of Deleted users for the Service_Locality Scope.
I have tried a few variations, but cannot figure out how to reference the columns / data generated when the report runs. Can anyone help me here? My MDX level is basic to say the least!