How to merge two rows data in straight table?

[#1]

HI,

I have data in straight table as below

READ	MonthYear	Enter	Gone	Ready
Stats	Jan 2013	3	3
Stats	Jan 2013	2		2

how to merge tow same READ rows so, I need out put as below

READ	MonthYear	Enter	Gone	Ready
Stats	Jan 2013	5	3	2

please can anyone suggest me how to do this?

Thanks.

[PrashantSangle]

Hi,

take Read and MonthYear as dimension and

Write expression for

Sum(Enter) for Enter

Sum(Gone) for Gone

sum(Ready) for Ready

Regards

[maxgro]

it sholud be already merged in a str table chart with 2 dimensions and 3 (sum) expressions

or I'm missing something?

maybe you have 2 different date on the same month in a calculated dimension formatted as MMM YYYY?

use =Date(MonthStart(datefield), 'MMM YYYY')