Please help me to solve this question. I need to calculate the %change, difference between quarter 4 of 2016 and quarter 4 of 2017 . As shown below, I have Sum(Sales) for different peer groups for last 5 quarters. I need to calculate the %change in sales between 2017 q4 and 2016 q4.

I have chosen Sample Superstore data set for this particular problem. In this case, if we filter 'Shipping date' for last 6 quarters, then we get 2018 Q1(which is our current quarter now). But we can't use 2018 Q1 sales in our calculation as it is incomplete because quarter has just started.

So what i am trying to do is, to calculate the %change in 2017 Q4 and 2016 Q4.

According to your previous reply, you have created a calculated field "current qtr" which returns the sales of current quarter. In my case i am not taking the current quarter for the %change calculation.

I have attached the screenshot for your reference. I look forward to your reply.

IF DATETRUNC('quarter',[Ship Date])={MAX(DATEADD('quarter',-1,[Ship Date]))} THEN [Sales] END

2. Last Year Qtr

IF DATETRUNC('quarter',[Ship Date])={MAX(DATETRUNC('quarter',DATEADD('year',-1,DATEADD('quarter',-1,[Ship Date]))))} THEN [Sales] END

3. % Change

(SUM([Last Year Qtr])-SUM([Current Qtr]))/SUM([Current Qtr])

Now i am trying to drag the %change field on Columns, because i want to have a different column in the view/crosstab which shows the % change. But while doing this i am not getting the desired output in the vie

I am using sample superstore workwook, the saved dataset in tableau desktop. This one is very large to attach. I am sorry for that. Therefore i have attached the screenshot of my tableau desktop view.

As per my knowledge you can't achieve the expected output in a single view. To achieve the output you've to use multiple worksheets in a dashboard. One sheet for your historical quarter sales and another sheet for your % change. But I won't recommend this approach.

May be someone else can take a look in your requirement and come up with some solution.

I am able to create a union with same table i.e Orders union with Orders1 as shown in your first screenshot.

I am sorry i couldn't understand the next step provided in your second screenshot. If i try to add the Table name (Orders1) in my column shelf, It comes in red color (an error) and what is the calculated field that you have put into text mark.