Income statement Financial KPI "Cost Item/Revenue" "Cost Item /Total Cost"

[MarcoG2000]

Good morning I have the following problem.

I have a model made up of a single completely denormalized table (see an excerpt of the fields below)

Field Extract: Year, Moth, Client, SubClient, GEO, Revenue1, Revenue2, Gross Salary; Social Security; Meal Ticket & Benefit; Telephone Charges; Postal Charges Other; Renting & Hiring; Power & Incidental Charges; Insurance; etc.

On this table I have created different measures to calculate intermediate results.

With this table I created a matrix with the "Show on rows" option (inside the Values ​​tab).

I have no column in the Rows field. In the Columns field, I put only the months field. All other fields are in the Values ​​tab.

I would like to add two more columns as per the image made on Excel.
The first field performs the ratio of each cost / intermediate item with respect to revenues.
The second field performs the ratio of each cost item to the total cost.

Thank you for your help.

[v-chuncz-msft · Accepted solution]

@MarcoG2000,

Currently, there is no elegant way. You may try to create a calculated table first.

[Anonymous]

Sam,

Can you please elaborate more about "calculated table"? Thanks!