count context multiple values

building reports webintelligence
1

Hi
I have the following data

id age country
1 20 US
2 21 India
1 20 France
3 20 Germany

and i need
cnt id age country
2 1 20 US
1 2 21 India
2 1 20 France
1 3 20 Germany

using cnt=count([id];all) in ([id]) doesn’t get what i want.
i tried with other contexts but still not a correct result.

thanks for help

petergemeni (BOB member since 2008-08-04)

2

It showing correct data only.

I think you need US, France in one row, Isn’t it??

Thanks

BOCP (BOB member since 2007-07-02)

3

did you ytu this

cnt=countall([id] foreach [id]) in ([id])

gokulBalaji :india: (BOB member since 2006-01-03)