Comparison between Last Year Quarter to Current Year Quarter

Question

Hello All, I have a requirement to calculate current year quarter comparison with the exact last year quarter ( ex: 2019Q2- 2020Q2). Picture is for reference- Regards

Tableau Community Forums Member (Inactive) · Accepted Answer

Try this,

For current year if {FIXED: MAX(QUATER([Date]))} = QUarter([Date]) AND

AND YEAR([DATE])= {FIXED : MAX(YEAR([DATE])) THEN [PROFIT] END

For previous year

if {FIXED: MAX(QUATER([Date]))} = QUarter([Date]) AND

AND YEAR([DATE])= {FIXED : MAX(YEAR([DATE]))}-1 THEN [PROFIT] END

For Growth, just do

(Current-previous)/(Current+ previous) then format to percentage

Alternative, you can make use of table calculation by using LOOKUP function

Mark as helpful if this helps.

neil van Asselt · Answer

Hi Ashish   You need two calculations. One for the current quarter profit   { fixed : sum(     if QUARTER([Order Date]) = {max(QUARTER([Order Date]))}        and YEAR([Order Date]) = {max(YEAR([Order Date]))}     then         [Profit]     end     )   ANd another  for the same Quarter 1 year ago.   { fixed : sum(     if QUARTER([Order Date]) = {max(QUARTER([Order Date]))}        and YEAR([Order Date]) = {max(YEAR([Order Date]))}-1     then         [Profit]    end     )   If this is the correct answer please mark as correct,   All the best,   Neil.

Comparison between Last Year Quarter to Current Year Quarter

Tableau Desktop & Web Authoring

관련 학습

도움 더 받기