Expression

[Ankit1988]

Above images are the excel data field Name

I want to create Expression in Straight Table 

Booking in Parent code = ('Pan India' or Zone and OEM wise total count of Relationship Code where 'Reason for no access' = 'Booking in Parent code')

How to create 'Booking in Parent code' Field in to Bracket there is logic 

plz suggest  

[sandeep-singh]

Hi @Ankit1988, From the above snapshot it not clear what you are trying to achieve in the table. Could you share some dummy or sample data to understand the logic you want to implement.

[Kushal_Chawda]

@Ankit1988  As per the logic it seems like below, but share sample  data and expected output if it doesn't work

=count({<[Reason for no access] = {'Booking in Parent code'}>} distinct [Relationship Code])

or

=count({<[Reason for no access] = {'Booking in Parent code'}>}  [Relationship Code])