Set analytics.

[#1]

HI, ALL.

I'm using the set analytics.

now table shows each sum like qvw file.

but, I wanna showing sum of each same column(as col1)

so far I used 'set analytics','aggr', 'rangesum'...

I don't know how to resolve this...

result I want is

month     col1      sum(col2)

1               a              63

                 b              63

2               b              47

                 c              47

3               c              51

                 d              51

4               d               27

thanks any opinions.

[jagan · Accepted solution]

Hi,

Try this expression

=sum(TOTAL<month>col2)

Regards,

Jagan.

[MK_QSL]

instead of sum(col2) use below expression as.

SUM(TOTAL <month> col2)

[#4]

Thank you!! Jagan!!