data presentation

[ssriramin19]

Hello,

   My requirement is that I need to show only the non zero numbers in dpa lag 0,dpa lag 1 and dpa lag 2 columns .Below is the table from teh table

Apr 2012	Dec 2011	0.00	358169182.00	0%	0%	-
Apr 2012	Jan 2012	0.00	434485823.00	0%	0%	0%
Apr 2012	Feb 2012	0.00	732762856.00	0%	0%	0%
Apr 2012	Mar 2012	0.00	1286501586.00	0%	0%	0%
Apr 2012	Apr 2012	0.00	241257800.00	0%	0%	0%
Apr 2012	May 2012	176753106.00	72396926.00	73%	14%	24%
Apr 2012	Jun 2012	214755.00	66785522.00	0%	0%	0%
Apr 2012	Jul 2012	17234.00	10892301.00	0%	0%	0%
Apr 2012	Aug 2012	380.00	10892339.00	0%	0%	0%
Apr 2012	Sep 2012	2.00	0.00	0%	0%	0%

Only the  values highlighted must be dised in the table.

Can anyone help me to resolve the above problem?

Thanks

[ssriramin19]

Can anyone please help me how to resolve the above issue.It is very urgent to complete

Thanks

[jagan]

Hi,

Can you attach the sample file.

Regards,

Jagan.

[jagan · Accepted solution]

Hi,

PFA file for solution.

Regards,

Jagan.