I have this table in my SAP Webi Report. I want to remove the dimension "UniqueActivity" but I don't want the values in the measure "CountOfReason" to change.

As soon as I remove that measure, this is what happens when instead I want the values in red to be shown inside the last column.

The whole reason I am asking for all this is because I am getting repeated items in my chart when i plot a bar chart against the first table:
