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

[Gysbert_Wassenaar]

I don't understand the problem? Can you explain what's stopping you from hard coding Offline_MF as XXXX for NA?

[mightyqlikers]

hi,

could you post with sample data and required output.

Regards

$@

[renuka_sasikumar]

Thanks for your prompt reply

Check it out the attached app

I want the value in Zonewise under NA

Regards,

Renuka S

[Gysbert_Wassenaar]

There is no NA in your data. Your document makes no sense at all to me.

[renuka_sasikumar]

There is no NA but I want to show as NA in Zonewise.

I have attached the sample data, here I have much data but which is very much confidential.

[Gysbert_Wassenaar]

You can't show things that do not exist.

[MayilVahanan · Accepted solution]

Hi

PFA

[renuka_sasikumar]

Thank you MAYIL VAHANAN RAMASAMY

[xavieravinson]

Hi Renu,

Please mail me the answer.