Power Query to create a new table and column that is sum of two columns from another table.

[Enkei]

Hello,

I have a table, I want to create another table which is a result of sum of two columns from another table.

[Fowmy]

@Enkei 

Not clear about the requirement. 
You can Right-Click the query and select "Reference", then group the columns.

 

[Enkei]

Hello @Fowmy 
I am attaching images below. I want the sum of female divided by sum of men in new table

[Fowmy · Accepted solution]

@Enkei 

Create a bank query and the paste following code and modify it as [per your table and column names. I attached a small file after my signature.

let
    Source = List.Sum(#"1"[Female]) / List.Sum(#"1"[Male]),
    #"Converted to Table" = #table(1, {{Source}})
in
    #"Converted to Table"