Grand Total by type of column

[Carlos_Raziel]

Hello, I have the following tables:

table name: Concentrado

table name: Empresa

table name: Moneda

The "Concentrado" table accumulates all the operations, the "Moneda" table indicates all the currencies in which operations can be carried out, the "Compañia" table indicates all the companies that can carry out the operations.

To maintain the format of the reports, I need that in the pivot table, all the companies and all the currencies appear even when they have not performed any operation. I solve this by uploading the information to the data model and relating them like this:

The following pivot table is created:

My problem is that I have not found a way to create a Grand Total per "Moneda". The result I am looking for is the following:

The truth is that I just discovered Power Query and I don't know anything about Power Pivot. Could someone help me solve my problem?

 

[daregu]

You can add calculated fields on them. Go to Power Pivot tab and click Measures. Then click New Measure. you can then make a calculated field for it that will calculate all that information.

 

[Carlos_Raziel]

You can add calculated fields on them. Go to Power Pivot tab and click Measures. Then click New Measure. you can then make a calculated field for it that will calculate all that information.

Thanks for the advice. Could you give me an example that I can use?

 

[alansidman]