Conditional Values in Null

[renuka_sasikumar]

Hi,

I have two chart as below

Source	Non POA Stock	OffLine MF
InDirect	XXX	0.00
Direct	XXX	XXXX
NAT	XXX	0.00
ESOP	XXX	0.00
Total	XXX	XXXX
Zone	Non POA Stock	OffLine MF
East	XXX	0.00
West	XXX	0.00
South	XXX	0.00
North	XXX	0.00
NA	0.00	XXXX
Total	XXX	XXXX

Here I have hard cored for Offline_MF  as if(Source='Direct','XXXX').

The same value I want in Zone wise but under NA. Is this possible can anyone help me.

Regards,

Renuka S

[renuka_sasikumar]

Hi,

Check the attachment attached by MAYIL VAHANAN RAMASAMY