I have need to display single month with added count

[balasundaram]

my issue: example

script:

bala:

LOAD * INLINE [

    name, count, month

    bala, 1, Apr 2014

    bala, 200, May 2014

];

Concatenate

LOAD name,

     count,

     month

FROM

F:\bala\qv.qvd

(qvd);

STORE bala into qv.qvd;

final report in straight table:

name	month	count	=1
			1
bala	Apr 2014	1	1
bala	Apr 2014	40	1
bala	Feb 2014	20	1
bala	Jan 2014	10	1
bala	Mar 2014	30	1
bala	May 2014	200	1

i took all fields in dimensions

i need to show apr 2014 count is 41 in single row

if i added in expresion sum(count) its showing 41

plz any one help how to solve this issue..

[#2]

If count is your field name, this expression:

sum(count),

will show you sum for your dimension values.

So, i understand, that your expression shows results exactly as you need (41).

regards

DArek

[#3]

bala:

LOAD * INLINE [

name, count, month

bala, 1, Apr 2014

bala, 200, May 2014

];

Concatenate

LOAD name,

count,

month

FROM

F:\bala\qv.qvd

(qvd);

STORE bala into qv.qvd;

FinalTable:

NoConcatenate

LOAD name,month,sum(count) as TotalSum

RESIDENT bala

GROUP BY name,month;

Drop table bala;

[its_anandrjs]

UPDATE SOME CHANGE IN THE SCRIPT

In single table you get this load your table like

bala:

LOAD * INLINE [

name, count, month

bala, 1, Apr 2014

bala, 200, May 2014

];

Concatenate

LOAD name,

count,

month

FROM

F:\bala\qv.qvd

(qvd);

left join

LOAD name,month,sum(count) as TotalSum

RESIDENT bala

GROUP BY name,month;

STORE bala into qv.qvd;

And on front end take table box and add the fields

name,month, TotalSum