calculating the max sum after a dynamic table,

[JEANCARLOB7]

Hi everyone,

I need your help. I want to calculate the max sum after creating a dynamic table. This is my table 

If i make a dynamic table i get this:

So,the result i want to get, either creating a mesuare or a calculate table would be:

I am forward to answering. 

Thanks a lot 

[calerof]

Hi @JEANCARLOB7 ,

With the simplest aproach, the sum of amount is:

Total = SUM( Total[Line amount] )

Then just use a KPI with multiple values and drag the Total grouped by Line, not by Customer, and you get this below:

Do these fit?

Hope it's what you're looking for.

Regards,

Fernando

[JEANCARLOB7]

Thanks Fernando for the soon answer but in the column extincion and tanques the max value would be 2750 and 77991 instead of those results