selected values

[sakamsureshbabu]

BRANCH	BRANCH  profit	BRANCH PROFIT SUM
B1	N	100
B2	0	200
B3	N	300
B4	0	500
B5	N	400
B6	N	100
B7	0	100

I need this data in poivt or stright table only which branch have "N" in BRANCH profit

DIM : BRANCH

EXP : ...................

[Anonymous]

Hi!

Take a look on the attached file.

Regards,

Gabriel

[sakamsureshbabu]

plz send attached file

[Anonymous]

Hi!

The file is attached in my previous post.

Maybe some error happened, so I'm sending again here.

Regards,

Gabriel

[maxgro]

adapt to your field (case sensitive)

sum({<[BRANCH profit]={N}>} [BRANCH PROFIT sum])