number of marked rows in script

[Naveen Tibco]

Hello,

I have property controls Year and Month and cross table as below..

 

Here i would like to know number of records for Store location and Gender when user selecting year and month ...

 

please guide me any expression or script for marked records and count the number of records to display in Cross table...

 

Thanks

Naveen

[Khushboo Rabadia]

count() will be sufficient to get count of rows. Anyways your cross table has Store location and gender on axes so whenever you markany cell, it will always mark records in a store for particular gender.

If your requirement is not this, please provide elaborated description, dxp or output screenshot, issue etc. in order to get valid/required answer for your question.

[Naveen Tibco]

Hello Khushboo,

 

Thanks for your inputs.

 

please find the attached DXP file .

 

in attached file i would like to get the count numbers of rows having 0 in value column.

 

Thanks

Naveen

[Naveen Tibco]

hi

[Khushboo Rabadia]

Dxp is not embedded so it shows 0 rows