Dont show row if next row is zero

[subbareddykm]

Hi all,

I have one requirement like below

PROJ	Phase	Start_Date	Exp 1	Exp 2	Exp 3	Exp 4	Exp 4	Exp 5	Exp 6\	Exp 7
1238	Phase 1	6/8/2016	0	0	0	0	1	0	0	0
1238	Phase 1	6/15/2016	0	0	0	0	0	0	0	0
1238	Phase 1	6/22/2016	0	0	0	0	0	0	0	0
1238	Phase 2	6/8/2016	1	1	0	0	1	1	1	1
1238	Phase 2	6/15/2016	1	1	0	0	0	1	1	1
1238	Phase 2	6/22/2016	1	1	0	0	0	1	0	1
1238	Phase 2	6/29/2016	1	1	0	0	0	1	1	0
1238	Phase 2	7/6/2016	0	1	0	0	0	0	1	1
1238	Phase 2	7/13/2016	0	0	0	0	0	0	1	0

In above data  for Phase 1 take min start date i.e 6/8/2016 to that i m getting i count for exp 4 remaing i m not getting that is fine , if i see for nxt date 6/15/2016 all are zero for all exp. i dont want see this date mean i want to restrict this row and but nxt if i have any value in any exp i want see all dates if zero also no problem.

I hope u understand this .

How to achieve this , can any one tell me on this  ?

[vishsaggi]

May be try this?

Use straight table and add dimensions (First 3 fields)

and expressions all exp1, exp2......exp7.

In presentation tab check Suppress zero values. as show below

[subbareddykm]

Thanks for ur responce but what i want is

But in yor case it will remove entaire row ,

My case

I should check Phase wise Max Date If max date is All zero remove and check Next date if it have value then show above all if it is zero .

[vishsaggi]

Quite did not get you. Can you tell me from the above table you mentioned, what dates should not be visible and what needs to be visible please??

[qliksus]

May be create a new expression which has values like

If (   (Exp1+Exp2+Exp3+Exp4+Exp5) =0 and below  (Exp1+Exp2+Exp3+Exp4+Exp5) = 0 ,0,1)

And change the text color of this to white to hide the display