Hi everyone,
I am experiencing the following problem. I have a table with the fields ID, GROUP, X, Y. I want to create a calculated dimension that, for each single record (identified by the key ID), must have the value 'A' if the ratio of the average of X and with the average of Y done over the GROUP of membership of the record is equal or greater than 1; 'B' otherwise.
I have tried different ways but with no success. Does anyone have an idea on how to do that?
Thank you in advance,
Valerio
