Naveen Tibco Posted May 17, 2019 Share Posted May 17, 2019 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 Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted May 22, 2019 Share Posted May 22, 2019 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. Link to comment Share on other sites More sharing options...
Naveen Tibco Posted May 23, 2019 Author Share Posted May 23, 2019 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 Link to comment Share on other sites More sharing options...
Naveen Tibco Posted May 23, 2019 Author Share Posted May 23, 2019 hi Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted May 23, 2019 Share Posted May 23, 2019 Dxp is not embedded so it shows 0 rows Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now