Min value from several tables in pivot table

[darofran72drf]

I have several tabs

tab1

GrupoContable | Month | ForecastEuros

Revenues | 1 | 100000

Personal |1 | -50000

tab2

GupoContable |Month | PersonalEuros

Personal | 1| - 45000

Personal | 2 | -60000

For the tab 2 I have the whole year - not for the tab 1. In the tab2 the onlye value for GrupoContable is Personal. In the tab1 ther are several values for GrupoContable and one of them is Personal

What I need is a pivort table with Grupo Contable (rows) and month (colum) ans the reslult shold be the minimun from ForecastEuros and PersonalEuros. And sum the totals

In the example tha righy values shoud be

January

Revenues: 100.000

Personal -50.000

Total -50.000

February

Revenues: 0

Personal: -60.000

Total: -60.000

Thanks

[Lisa_P · Accepted solution]

To replicate your data, I loaded inline and changed the structure to load all fields into one table (autoconcatenate):

tab1:
Load GrupoContable,
Month,
ForecastEuros as Amount,
'Forecast' as Type;
Load * Inline [
GrupoContable, Month, ForecastEuros
Revenues, 1, 100000
Personal, 1, -50000
];

Load GrupoContable,
Month,
PersonalEuros as Amount,
'Personal' as Type;
Load * Inline [
GrupoContable, Month, PersonalEuros
Personal, 1, -45000
Personal, 2, -60000
];