Intelligent summarizing

Hi Experts,   How are you guys ? I am stuck at below scenario, Suppose I need to create a report which shows "Profit Amount by Location" where in Location dimension say "London" exists thrice, 1 ...