Hi all.
I have Categories X, that can have values X_1 and X_2 and Y, that can have values Y_1 and Y_2. The variable That I want is defined as the product of the fraction of all records for entity E that have X_1 and Y_1. For entity E I have many records. So for a given entity, I have many lines that in column X show either X_1 or X_2 and the same for Y, and in some graph I want 1 number per entity that has (number of X_1 for entity E divided by total number of records for E, times the number of Y_1 divided by the total number of records for E). Anyone has an idea of how I can do that?
Thanks in advance!
Marcel