Merging rows in a straight table

[#1]

Hi Folks,

I have the following requirement which I need to complete. It is :

I have the following straight table :

Header 1	Header 2
A	12
B	10
C	15
B	20
A	25
D	30
A	40
B	50

I need the output as

Header 1	Header 2
A	77
B	80
C	15
D	30

where header 1 is a dimension and header 2 values are measures.

And values of all the measures are either stored in variables or  expressions in another part of staging.

How to do that?

Please share your thoughts.@

[vishsaggi]

What is the issue here?

Use straight table,

Dim: Header1

expr: Sum(Header2)

Then for expr in expression tab use No Totals from the Total Mode you can see that in bottom right corner .