Group by two columns and add other column values

[maheshchubb123]

I have the table data in below format:

Requirement:

I want to group by API Name and Resource Group and calculate the Total Expected Cost and Total Actual Cost.

And the result would look like below:

Given the sample input and expected output below for reference...

Input: 

API Name	Resource Group	Expected Cost	Actual Cost	Month	Year
API 1	RG 1	10	15	1	2020
API 1	RG 1	20	25	2	2020
API 1	RG 1	30	32	3	2020
API 1	RG 1	40	40	4	2020
API 1	RG 1	50	55	5	2020
API 1	RG 1	60	65	6	2020
API 1	RG 1	70	75	7	2020
API 1	RG 2	10	15	1	2020
API 1	RG 2	20	25	2	2020
API 1	RG 2	30	32	3	2020
API 1	RG 2	40	40	4	2020
API 1	RG 2	50	55	5	2020
API 1	RG 2	60	65	6	2020
API 1	RG 2	70	75	7	2020

Expected Output:

API Name	Resource Group	Total Expected Cost	Total Actual Cost
API 1	RG 1	280	307
API 1	RG 2	280	307

[Pragati11 · Accepted solution]

Hi @maheshchubb123 ,

You don't require any transformations for this. Just move the columns to a table visual you will get the required output:

Set Summarisation for Expected Cost an Actual Cost to SUM:

Thanks,

Pragati