How to group all the profit values of each year for each country?

[Anonymous]

Hi,

In this data, we have many tables that represent the profits for a real estate company which have many branches and agents in many countries.

I want to predict the profit value for next years based on the available historical data and some criteria like GDP, Crime index, Density, Urban, Unemployment rate, etc...

I think, at first, I need to create a table that includes: countries names, total profit, years and other criteria values.

The first issue that I faced is to group the years to show the total value of those profits per year in each country.

Please have a look at the screenshot 

[lbendlin]

I only provided pseudo code as I don't know your data model.  Use CALCULATE() etc as needed.

[lbendlin]

Create a new measure that adds these values. Something like this:

Total Profit = sum(Rentalprofit) +sum(Salesprofit)

[Anonymous]

Thanks again Ibendlin,

I think your suggestion's measurement is to get the sum of (total profit) for all years together, as a new column. Unfortunately, it's not working as you can see from the below screenshot. I think that because we have 2 titles or references for each column, one for years and another one for the type of profits (rent or sale).

I hope I could get an idea of how to find the (total profit) for each year

  

[Anonymous]

Thank you so much Ibendlin,

Just one more thing please, Now I got 2 values for each year, the Rental and the Sale, as you can see attached screenshot. How to get only the total value for each year?

need 1 value represent rent and sale

[lbendlin · Accepted solution]

Use a matrix visual rather than a table, and put the years into the column area.