Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can anyone please help me how to resolve the above issue.It is very urgent to complete
Thanks
Hi,
Can you attach the sample file.
Regards,
Jagan.
Hi,
PFA file for solution.
Regards,
Jagan.