Hello.
I've got a crosstab report with rows based on a Product ID, columns based on the Gender of the customer, and the crosstab intersections is the number of members who bought the product for that gender. I'm trying to create a query calculation for the row that give me just the % of products sold to Female customers ('F') for that product row.
I'm looking for output to be the Product, # products sold to men, # products sold to women, total products sold, percentage sold to women for each line of the crosstab.
I've tried count([Member Count] for {[Product Id (PDPD ID)],[Member Gender]='F'}) / count ([Member Count] for [Product ID (PDPD ID)]).
I've tried if/then conditional calculations.
My validations always come back as ok, but the results in the report always comes back as the report total (grand total of all products sold).
Any ideas or pointing me in a general direction would be most appreciated! Thanks much!
are you using dimensional or relational?