Variance in Matrix showing twice

[Anonymous]

Hi,

I have a measure to get variance betweeen 2018 A & 2018 B, but it is appearing twice, I want it to only appear at the end.

Measure = CALCUALTE(SUM(table'Value'),table'ABFlag'="A")-CALCUALTE(SUM(table'Value'),table'ABFlag'="B")

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.

How do I only make the Measure appear once?

Cheers

[amitchandak · Accepted solution]

You want Measure to appear once and Value to appear twice?

In any case , you might have to remove AB flag from columns

[Anonymous]

@amitchandak Thank you! I am not sure what I was thinking... this makes the matrix better as I do not really need to show budget value if I am showing the variance.  Cheers!