
1. Re: Variance of 2 columns of the same Measure
Deepak Rai Oct 30, 2018 12:01 PM (in response to Tony Nguyen)You need to Format the Dimension Make and Left Justify it. Is that you need?

2. Re: Variance of 2 columns of the same Measure
Tony Nguyen Oct 30, 2018 12:06 PM (in response to Deepak Rai)Hi Deepak,
Essentially all I want to do is subtract 2017 and 2018 to see any growth. For example in 2018 there were 2,863 units sold and 2017 there was 2,321 sold. I want to create a column that shows this difference.
So the column (For Acura) would have 542. Does that clarify my question?
Thank you for responding so quickly,
Tony

3. Re: Variance of 2 columns of the same Measure
Deepak Rai Oct 30, 2018 12:25 PM (in response to Tony Nguyen)1 of 1 people found this helpfulYes use this calc
SUM({FIXED Make:SUM(If Year(Report Year)=2018 then Number of Records END)})SUM({FIXED Make:SUM(If Year(Report Year)=2017 then Number of Records END)})

4. Re: Variance of 2 columns of the same Measure
Tony Nguyen Oct 30, 2018 12:48 PM (in response to Deepak Rai) 
5. Re: Variance of 2 columns of the same Measure
Deepak Rai Oct 30, 2018 12:56 PM (in response to Tony Nguyen)Looks like you added them. When you get Correct results, you please close thread by marking my Reply as Helpful and CORRECT

6. Re: Variance of 2 columns of the same Measure
Tony Nguyen Oct 31, 2018 6:55 AM (in response to Deepak Rai)Hey Deepak,
Please see below for the snippet of my workbook. The header with Forum Help is your formula. I tinkered with it to see what is happening and no matter what I did the numbers never quite lined up to what I wanted.
The Unit Change header is what I saw from another forum which is  SUM([Total])Lookup(ZN(SUM([Total])),1)
Which solved my problem, sort of, now I can't hide the 2017 column for JUST 2017 Unit Change, it hides both the Total and Unit change column 2017's. Regardless, that's minor.
Thank you again Deepak for all the help!
Tony