
1. Re: Percentage difference duplicating for 2 different metrics
swaroop.gantela May 16, 2018 7:48 PM (in response to Melanie Ceder)Melanie,
There likely is a way to get it to work using the Quick Table Calculation method,
but I couldn't quite find it. However, I was wondering if it would suffice to write a new calculated field.
On your Percent Difference sheet, I tried a calculation with Visits and used a roundabout formula of:
IF ATTR([Total].[Time Period Test])="Current Year" THEN
(2*SUM([Visits])  TOTAL(SUM([Visits]))) / (TOTAL(SUM([Visits]))SUM([Visits]))
END
This way the only Table Calculation is the Total which seemed to work
when setting a Compute Using of "Table Across". It did have the drawback
of having the empty Last Year column.
I didn't thoroughly check to see if it was producing all the right numbers,
or if it would work for all of your measures.
Please see workbook attached in the Forum thread.

269826diff_v10.4.twbx 249.9 KB
