But i want the table to display all segments and values and instead of the '5623' in red, a '0'. something like count distinct(If(Segment_1 = 'NewCustomer' and Segment_2 = 'LostCustomer', 0, contact_id)
My dimensions are
Segment_1 =(Segment A, Segment B, Segment C, Segment D, NewCustomer)
Segment_2 =(Segment A, Segment B, Segment C, Segment D, LostCustomer)