count number of 0 in cross table cell values

[Naveen Tibco]

Hello,

I am using cross table

Vertical Axis i took Country and State.

Cell Values i took Sales and Unit Price.

In Sales and Unit Price having "0". I would like to count number of 0 in cell values.

 

please find the attachment for the reference.

In the Attached example 5 rows having '0's. How can we do calculation for count of 0 in cell values in spotfire

Thanks

Naveen

[Gaia Paolini]

A possible solution would be to create extra columns in the cross table that are 1 if the sum of sales or unit price is zero, and zero otherwise, and sum them in the grand total.

See attached sample dxp

Gaia

[Naveen Tibco]

Thanks for your input.

 

Actually i would like to get count of all Cell Values having 0 in 2 columns .

 

from the your attachment i am getting 2 column indiviual count would be 3(IsZeroSales)+2(IsZeroUnitPrice)=5. But in my Actual Requirement having More columns(sales,unitprice....more) in Cell values axis and those columns having 0 . i would like to get count for all cell values having 0.

 

Thanks 

 

Naveen