Percentage by dimension

[spividori]

Hi.

I have a table with the following data, year, origin and quantity.

I need to know the percentage per year, but not on the total, but show me each year.

File Attachment. Thank you.

Regards.

[hic · Accepted solution]

You should use

     Sum(Unidades)/Sum(total <Año> Unidades)

as formula.

Further, you need to uncheck Expressions->Relative. You should probably also format the number as "Integer" and "Show in Percent".

HIC

[spividori]

Hi Henric.

Thank you very much, is what I needed.

Regards.