Variance in Matrix showing twice

Question

Hi,&nbsp;I have a measure to get variance betweeen 2018 A &amp; 2018 B, but it is appearing twice, I want it to only appear at the end.&nbsp;Measure = CALCUALTE(SUM(table'Value'),table'ABFlag'="A")-CALCUALTE(SUM(table'Value'),table'ABFlag'="B")&nbsp;I previously had each of the attributes listed as indivudal columns, but have now unpivoted them to create the measure for variance, rather than variance for each attribute.&nbsp;&nbsp;&nbsp;How do I only make the Measure appear once?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cheers

amitchandak · Accepted Answer

You want Measure to appear once and Value to appear twice?In any case , you might have to remove AB flag from columns

Forum Discussion

Variance in Matrix showing twice

2 Replies

Related content

Budget, actual and variance matrix

Simple Matrix with Variance

Add Variance Column to Matrix

Multiple variance calculation in matrix

How show quantile in matrix