It is possible with conditional expression, see attached
Edit: This is just an illustration. As for calculations, depending on what is needed (avg and sd dev on month level vs. record level), you maybe need this instead of Amount in the aggregations:
Multiple totals.qvw 158.2 K
Thank you VERY Much. It's not pretty but it works!!!
I'd prefer to have it as a avg/stddev of the Months rather than the year. But that's just changing the 'Show Partial Sums' at the Year and not the Month.
But more importantly I wanted to see the StdDev and Avg as two separate rows, rather than a single rows with two values. If you know how I can achieve this then it would be perfect.
But it seems to work.
Is there anyway of applying the Visual Cues on Totals that is constructed from conditional expression below?
Such that if the Avg or Stddev>0 then it's 'green' else 'red'?
(Dimensionality()=1 , SUM(FS_Fund_1M_Rtn),
'Mean : ' & num(Avg(FS_Fund_1M_Rtn), '##.##%') & chr(10) & 'StDev : ' & num(Stdev(FS_Fund_1M_Rtn),'##.##%')
Try attribute expression for the background color (or for text color), probably this:
if(Avg(FS_Fund_1M_Rtn)>0 or Stdev(FS_Fund_1M_Rtn)>0,
See my example attached. It is different but illustrates the aproach.
Multiple totals2.qvw 158.5 K