need expression for following scenario

[#1]

i have a scenario i want to display the rows which contain lead,opportunities,contacts=0

please find the following attachment

[#2]

i need straight table like 2nd sheet in excel

[senpradip007]

No 2nd sheet is there in the excel.

[#4]

!

[fashid]

There is no second sheet friend. please check your attachment

[#6]

sorry plz check this one

[senpradip007]

Where the attachments?

[#8]

sry once again olz find the below attachment

[#9]

Hi,

Try this:

for count of activity id where lead,opportunities,contacts=0

=count({<response={0},oppty={0},lead={0}>}[activity id])

Thanks

khushboo

[antoniotiman]

Hi,

You can use calculated dimension as

If(response=0 and oppty=0 and lead=0,[activity id])

or Aggr(If(..........,[activity id]),[activity id]) if You need.

Regards,

Antonio