I am using a variable to store some expressions which contains set analysis. Herewith an example:
SET vGrossSales = =Sum({<TypeParent = {'Sales'}>}Amount);
When I display this variable by using vGrossSales (with / without dollar expansion), it works fine. However, If I add Months as an example to the dimensions, it adds them together for all months selected, and doesn't display the month sales individually.
I thought that it might be to do with the fact that the variable starts with =Sum and not just Sum. But that doesn't seem to work. I have also tried LET, but to no avail.
As mentioned, it is working fine, although I just want to be able to calculated the expression 'on the fly' by different dimensions.
