Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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 .
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??
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