Double total in a straight/Pivot Table

[QlikDeveloper]

I have two tables(refer the excel) which can be merged into a table based on requirement.

I need the Output as mentioned in the attached spreadsheet.

Population is not a static field hence I have to achieve it in the QV Dashboard Layer.

[lironbaram · Accepted solution]

hi 

have a look at the attach example 

it close to what you look for and leave you with allowing the user to make selections 

[QlikDeveloper]

Thanks Lironbaram for your quick response. I think it will work after some modification.