This content has been marked as final. Show 4 replies
Community_208010.qvw 152.0 K
I have a ridiculous chart to create :-) with hundreds of columns (but will control show / hide via conditional to make it usable).
Entering expression on screen for this volume is a nightmare, so what I want to do is load something like this...
LOAD * INLINE [_MetricCode,_Metric_Name,_MetricExpression
MAA, Sales ,sum(SALES)
& then have a chart that uses the expression..
.. hoping the resulting expression column would be the sum of my sales i.e. £100
... however I am getting the 'text' as a result in the column i.e. 'sum(SALES'.
Is there a way please to tell the expression the result is a formulae ?
Thanks in advance