How to remove the 1st row of my P&L table report.

[#1]

Hi All

I have a table is working fine. Just that i need to remove the first row of the number. Hope some one can advise me. ( See my QV doc )

[#2 · Accepted solution]

Hi,

In your chart dimension use =if(Seq>1 and len(Trim([Exec P&L Heading_]))>1,[Exec P&L Heading_] & ' ' )

[#3]

Hi Abh

You are very good, it work now .since it move to last line , it is okay not so bad since it is not appear at row 1.

if possible can you share with me how to remove the last row. Thank

Paul

[#4]

Hi Paul,

Use suppress when value is null in chart dimensions tab