How to aggregate the measure values to one dimension values

[rohit_shoppertr]

Hi team,

My requirement says Sum of the field or  aggregate with sum function w.r.t columnA, 

Raw data:

ColumnA ColumnB   A U 10 A V 10 B X 20 B Y 20

Required table:

ColumnA	ColumnB	Measure
A	U	20
A	V
B	X	40
B	Y

So, I want to group by Field on column A.