2 Replies Latest reply on Oct 31, 2018 5:05 AM by Marilynn Jouse

# Calculate 4 week, 12 week and 52 week YOY between customers

I have a workbook where I need to calculate 4 week, 12 week and 52 week YOY unit % change.  Data is in increment of weeks.

So far, so good.   Found multiple ways to do that.   HOWEVER, I also need to add a line showing the difference between the chosen customer and the rest of market.   So, for the attached workbook, the values for the line would be Line would show below.   Any ideas?  I'm new to Tableau and have been unable to find a solution, even an alternate solution that would show the values in each pane.  The attached workbook is 10.5.3

 CustvsROM 4 weeks 12 weeks 52 weeks Customer1 -1.58% -7.03% -2.07% ROM 4.12% 1.49% -0.73% Line would show -5.70% -8.52% -1.34%
• ###### 1. Re: Calculate 4 week, 12 week and 52 week YOY between customers

Hi, Marilynn

Below is the screenshot for your reference.

Hope this helps

ZZ

• ###### 2. Re: Calculate 4 week, 12 week and 52 week YOY between customers

Unfortunately, i had the same thing happen as in the other solutions I tried -- it works on its own, but as soon as i try to add to the original chart as another measure, it ends up with all nulls.    When I remove the custvsROM dimension it displays properly, but that is not giving me what I need.

I created a Cust YOY % Change and a ROM YOY %  change (YOY v2 in attached workbook)  -- getting closer, but I cannot get the YOY Change Difference between the two to be a line -- shapes, yes, but a line no.