I have an expression called Range which is equal to
I would like to create another summation similar to this
sum(total <Range> Members)
Is this even possible? if not what can I do to work around this.... ?
It sounds like your "Range" should be a calculated dimension rather than an expression. Also, the syntax above for Range won't work in QV since you have nested aggregation. Try taking this to a calculated dimension (using function aggr over dimension Member probably). The expression of the chart would just be sum(Members)